Search results

we will have alot of redundant data in my database (but its somewhat necessary for what we are using this for as we need a history of records and relationsihps that change frequently) i havent used a lookup yet.. i have this main table which is pretty much the fields in my database we need...

im somewhat of a novice with Access so if possible could someone walk me through it Uncle Gizmo - i think you may be missing the issue where i am able to get the combo box itself to be recorded in the tables field but i need a field dependent on the combo box's selection (which comes from the...

Hello, i'm trying to make a form in which one field is automatically populated from the selection in a combo box (which pulls from a table) Bascially i have a list of unique entity numbers and unique entity names. What i want to have happen is i select the entity number from the list and the...

seems like i am having a VERY similiar problem... my form works fine to duplicate and move to next record as is when no code is added, but when i added the code to make fields visible/invisible based on a click box, when i click "duplicate record" or "next record" i get "invalid use of null...

Per another post i went in to all my Y/N fields and changed their default value's to NO... that seemd to do the trick.. if you have any comments about my other issue please let me know Thanks so much for your help

I will definitely try this.. acutally, I recall coming across a code that made a button click that automatically duplicated the record and saved changes to it as well..? On a side note, the next step of the project is to have forms pop up, or tabs or something to fill out when a certain button...

I'll explain this project to see if someoen knows a better way to do this since im getting an "invalid use of null" error.. We have a field (stat audit yes no), that when clicked needs to make the other fields appear. The code below does that well. However what we are attempting to do is...

Wow - that was easy... thanks so much! you guys are quick I'm sure i'll be back with more questions but that really helped alot...

Hi - thats the problem, im not sure what code to write - all i have entered is this Use this in the Checkbox's After Update event and also on the form's On Current event: Me.YourTextBox.Visible = Me.YourCheckboxNameHere (clearly updating for my field names - as a side note, can field names...

I'll start by saying i have zero experience with macros but, have the same exact quesiton as the above individual, however, i have placed the code as specified (with my fields replaced) in the on current procedure as well as the after update procedure of the respective items.. however, when i...