I've been playing with more distributed data in a DB I'm setting up for a friend. The Database has a number of tables with relationships to other tables. ...

I tried to add an AutoNumber column using a Macro, but it did not work. The SQL I used was: ALTER TABLE 12 ADD COLUMN ID AutoNumber Can anybody please help...

How do I get Loghorn or the most cutting edge version of Microsoft Computer system free, online, and to achieve all this via, all access and free downloading...

My predecessor designed an Access DB where a query for an Address is run and the corresponding property information would be displayed in a form. The form...

I increased my RAM and added a new graphics card on my computer running Windows XP. After a few days I was asked to reactivate windows because of the...

I have set up a database for my local Credit union. I have set the member's id number as an integer in a member table. I have set the format as "fixed" and...

How can I generate account numbers with the first 3 charters "ALS" then numbers after? Example: ALS3000 ALS3001 ALS3002 can...

I have created a database using Access, and filled it with data to test it. Now I want to empty it, and prepare it for distribution. What is the best way to...

Hi everybody, I get a little problem maybe one of us can help me, Every day I' get a download a "Shorts Report" of every number parts, and this file in .txt is...

Hi Can I limit the datbase usage to a CD by using a serial number or something like it? Thanks Armon

Hi all ! I have a strange problem here : I am inserting data from a linked table into a local table (it is a table i my frontend, that I use as a temporary...

if a table with two columns column A represents Column B (two different codes same item) i can't get away from that but on my form i need to be able to...

I WOULD LIKE TO ACCESS A TEMPLATE THAT WOULD HAVE DAYS ON THE ROWS AND MONTHS IN THE COLUMNS. DOES ODDICE 2002 HAVE SUCH A TEMPLATE, IF NOT WHERE CAN I FIND A...

I have recently switched from Access 2002 to 2007. I am now receiving an error message: "Property Value is too large. Property Value cannot be larger then...

I am using MS access 2003, I need to set uo a validation rule for a number field, that will only allow 3 or 4 digits, any other number that is not 3 or 4...

I'm importing HTML into an Access table and then allowing the user to view this data through text boxes on a FORM. The HTML tags are currently being stripped...

I can't figure out what the rules are for foreign keys in tables. For example, M:M is easy -- the table includes the PKs of the two related tables. In a 1:M...

I am producing report that has many books listed, and I want to add the jpeg image of each book in the final report. How do do I accomplish this?