Search results

Hi i have another fairly major issue that i need to fix asap. Heres the code: Dim statusFlag As String Dim response As String Set db = CurrentDb Set r = db.OpenRecordset("defectTable") r.MoveFirst Do Until r.EOF If Forms!afterDefectViewForm2.flag1 = "1" Then statusFlag =...

yeh, i normaly name my tables and queries fairly well, and i did mention i was a lazy programmer, so thats the reason i dont change my button names, i know i should but... :P

Fantastic, thanks Peter, that was exactly what i needed :D

I have tried it Curtis, but once i select the first field and select an item from the combo box, it then prompts me that i havnt filled in the other fields, even though i dont want the error checking carried out till the Save button is selected. Any Ideas how to sort this out?

The problem is, i still need an identifier to progress to the save option. so if i have your code and then the save section in the button click, it will check all the fields, and if the fields are empty, it will display the warning, then go on to save (which i dont want). So i need something to...

can you past all the code in please in one of the events?

Thanks for your help. Im a fairly lazy programmer, and i must have never fully taught myself declaring the variables correclty. Anyway, the reason why i have those responses is because i need the code to know if the field is fill in or not! if its not, brings up an error message. if it is, then...

happy to help :) and sure, ill always be around, if not, im sure you can always send me a private message! but then again, theres a forum of people here to help :P

i would put it on the 'On Change' property. So everytime you selected one of the options from the combo box, it will run the code :)

you could have something similar to this: if 'combobox' = "No" then button.enabled = False end if and to enable it, you would put something like: if 'combobox' = "Yes" then button.enabled = True end if Remember 'combobox' is the name you called your combo box and same goes for...

Hi Sorry to be vague in the title, im not completely sure what it falls under. I have an issue that in theory, should work (I think) but its not. I have been sitting here for the past few hours pulling out my hair thinking hard to why it’s not working. My access isn’t that great so im sure the...

Hi there I believe what i want to do is fairly tricky. I have a defect form where the user can enter in defects and click 'ok' to save the record and goes to the next free record for another defect to be entered, while an auto number is generated for the ID. You can also cancel out which wont...

Hi there, i have a master reset to delete all the data in the database. Although, as there is a username and password entry to get into the admin module, i wish for one entry in the table participantTable to not get deleted (to save one password/username so its possible to log into the admin...

Fantastic, thanks :) and thanks for the tip

Hi I have a subform on a form. All the fields on the form and subform are locked and not enabled. I have a amend button which should unlock and enable the fields on the form and subform, although, i can unlocked and enable the fields on the form, but cant seem to do it on the subform, the code...

I have multiple forms, one of which you can view meeting details (form 1), if a mistake is spotted, there’s an ‘amend’ button which brings up a text field to enter in the description. Now I have another form (form 2) that you can view the meeting details later on, and I want it to display the...

Ah, fantastic, thanks :D

How can i do that? Sorry, im still fairly new to Access.

Nearly there, although, im having trouble with my query for deleting all records in all my tables: DELETE [defectTable.*], [meetingTable.*], [cdsidTable.*], [participantTable.*], [phaseTable.*], [productTable.*], [programTable.*], [workProductTable.*] FROM defectTable, meetingTable...

thanks for the reply, although i have a couple more questions. I created a query to delete the records in a table (just one table for the moment as a tester). As i want a button to allow me to activate this query, i created a button (using the wizard) and when i select to 'run a query', the...