I need to compare product codes from various souces. Some will use various characters to separate a string of numbers e.g. 1234-5678 or 1234.5678 Both are the...

Here is the statement... SELECT *, rand() as random_number FROM image_img ORDER BY random_number DESC LIMIT 1 I suspect that the rand() is not supported in...

Hello - My computer at work was recently upgraded from Windows 2000 SP-4 to Windows XP Pro SP-2. Previously, I was able to perform a search (Start Search ...

Hi everyone, I'm having a very difficult time with the Access security and I'm hoping someone can point me in the right direction. I have an Access 2000...

How would I disable all fields on a form for a specific record? Right now I have a checkbox set up that controls which fields are enabled/disabled but is there...

Hi, I am designing a form where I have a drop down field that has several columns. When I choose the selection from the drop down I'd like the the information...

This is a sub to open the File Open dialog box. I've copied and pasted this out of an Access VBA book (Microsoft Access VBA programming for the Absolute...

i tried to convert my a97 db to a2k3 db but it gave me an error saying that "base rowlineage" field doesn't exist in "Msys Tombstone".i needs clarification on...

I have an access 2003 dbase that needs to store in excess of 70-80 records for the purpose of reporting to a government agency. Client Status and Demographic...

Please help, how can I show this in a form of an access database? AutoID ProjectName 1/1/05 1/2/05 1/3/05 ...... 1/31/05 1 Proj01 4...

I'm working on a data base program powered my access 2003. This program will power the sales department and the back office, because it’s a simple setup...

Is there a link somewhere that will show me examples -- and how to go about creating custom menus and toolbars for my users? I want the ability to create...

I posted a week or so ago and thought I had an answer, but now it doesn't want to sort correctly. The field name is LotNumber. I need to convert it to a text...

What exactly is a lokup table and when to use it. Emilio

A little help will be appreciated. When working with Windows 2000, I can have multiple forms in my task bar but when I use Runtime, there's only one and I...

How can I calculate the number of work days (no Sat, Sun or Holidays) between 2 dates and use this for present dates and future dates?

I'm building a database to help my school keep track of textbooks. We label every textbook with an ID number, and each student is responsible for turning in...

Is there any way to create a button that allows the user to select a file, and attach the content of the file to a particular database. I am trying to create...

I have a Access 2003 datasheet and I want to lock all fields in the first few number of rows, but I do NOT wnat to lock all rows in the datasheet. Can I do...

I have an option group with 2 options in it. How would I write an "IF" statement to say when one option is checked then make field1 visible on my form and when...