I want to create a combo box with, in order, Detached, Semi-detached, Bungalow, Flat, Other but the choices KEEP appearing alphabetically. I would be...

hi can someone help me to round numbers up or down, so if a number is 9.3 it would go to 9.5 and if a number is 7.8 it will go to 8 any help would be greatly...

Hi all, i have a netwok application that read tables in 3 different mdb files. Would it be a good idea for the network load to put all the table in one mdb...

i would like to have a number required in a field, but only when a specific text is present in another field of the same table using Access

Can I use an "If" statement in the critera of my query? If so, I am trying to return a value from a table in one column based on the condition of another...

I want to save 192 bit-values in 12 integers. How do I save this information in a field in a table? Can I save it in a text field – and how do I the extract...

I have created a query and want to print the entire query window on 11x17 paper? I am trying to show the joins involved with this query so I can take this to...

I have a table where I want to match up product names with a .jpg picture of the product. All the .jpg product picture files are in a folder on my...

I am importing data from Excel to an Access table and some of the "timed" data is longer than 24 hours. I need to be able to calculate, or run a query based on...

I am in the process of designing an access file to sort and analyze data from a survey. There is one survey question that has multiple answers (respondent can...

Access 2002. I have a table with a hyperlink field that I want to populate with drawing image files related to the records (inventory parts). Our drawing...

Hello, I have a temp table that is created from code to use for printing a report. It works great except for a field used for middle inital. If a...

How do I create a Data Dictionary report (table name and description + column name and description) from either Access or Visio after the database has...

How can we apply the valdation rule to the new records only. This means that the old ones should not be affected by this rule at all

Some authors always make the foreign key also a primary key; while other authors make the foreign key a non-primary key. Question? what is the difference in...

Well, not really...but my front end doesn't show them anymore. I had to add some security, which for me a databse password was enough. I ended up relinking...

Hi there, Ive been a bit to ahead of myself, and i need to add some buttons to my form - but, ive set up within start up to have all my menus dissapear (all i...

There must be a way to get a list of a database's tables into a text file. Any list of the tables I see in Access can't be tagged and put into the clipboard....

I am trying to design a table that has the current database user defaulted and validated in a "UserName" field. But, when I put the...

I am wondering if there is software out there somewhere that can be used to run elections for associations board of directors? Any suggestions? ERIC