Search results

bump for myself. I hope that is not breakin board rules.

Hello All- I am still very new to access so please bear with me. I need to be able to prompt the user for a date before running the report. I want the user to be able to use a date picker for the date. I then need to exclude all items but those in which [datepaid] = user entered date. I am...

FANTASTIC!!! This works just like I hoped it would :P Excellent!!! Thanks alot. I am now able to create new records and have that autonumber key propigate to the subtables/subforms!

really? I guess I didnt think it would be that "out of the ordinary". I guess I dont understand what the problem would be...I have a form that recieves an autonumber upon creation...I want that to pass that autonumber to a field in a table on the subform table so the records will be linked...

Guus thanks for your help so far..but I am still wondering how to pass values from one field in a table to another field in another table. Do I use maco or querys? Just not sure how to accomplish this.

Well I guess I wasnt sure how to make a primary key column that wasnt autogenerated to make it so it picks up from where the last one let off. I tried to just switch it and it earased all my imported key and replaced them with auto generated keys. But since the documents are linked by the...

Hello all, I am very new to access but I hope this isnt too difficult to accomplish. I have a client form and on the form I have a tabbed sub from which pulls in data from other table based on a primary key. Well Since all of these docs were imported from Lotus Notes the primary key is a long...

Well I dont know if using Vista is an issue or not but I am using it. The file I am using is on the network. I do have another xp laptop I could use. I will re install office 2003 on the vista machine and see if that works too. Just seems like no matter what I do...I lose part of my work because...

Hello everyone. I will admit I am a novice when it comes to access. But I do have some programming background in Lotus Notes. Now maybe its just me but Access seems to error out ALOT and I keep getting messages like: -File is not a databse -A user unexpectedly shut down access -Some c++ runtime...

So do you mean add a new column to the existing data for a numeric key? and use this for all new records? and what do you mean by keep both tables in sync? Sorry I hate to keep pushing on this issue..but I feel like a ignorant ass in access..... I do appreciate all your time and patience in...

Neil, Thanks alot for the help. Sorry I didnt reply sooner. I tried the append Query and I am getting a type mismatch. The PK on the existing table is alphanumeric and by default the auto number on the new table to append to is Long Integer....If I switch this to Replication ID the query...

ugh I am so confused....

OK I think I understand about the child keys. Another question if you dont mind....I already have a primary key on the main form..can I add another primary key to it for new records that auto generates keys? And of course this would need to link to the primary key on the child records.

Well the only problem with the child tables not allowing dups is there can be more than one child record per main form.. Example: Main client form: -Child Assistance form for work Boots -Child Assistance form for another pair of work boots Both of those child form will be in the same child...

Thanks for the reply. Yes I am using subforms to link the data. Like I said all that is working fine for existing records..I can flip through no problem..edit no problem...its the new documents where the autoassign needs to pick up(for the main form...and hopefully it will pass the info to the...

Hello everyone, I am having some issues getting past primary keys. A little background on what I am doing: I am a Lotus Notes Programmer by design. We have decided to move away from Lotus and Access seems to be the choice to replace some of our applications. I have created a DB in access 2003...