Search results

Hi RuralGuy, The controls on the subfrm2 pick up their data (date) from subfrm1 when I open subfrm 2. the values are not stored in a table ( ithink this may be the problem) My Report needs to pick up the date in the control from either sub1 or sub2. I thought it was more logical to pick up the...

No ita a typo

Thanks for the help but still the same #name? error problem. Getting frustrated now...! Could it be perhaps that the value in subfrm2 control is not stored in a table?

Thanks for that but srtill getting #name? error:(

Hi Deninsk,thanks for the reply, unfortunatly I get #name# error, not sure whats going on here. I dont seem to be able to reference the value in subfrm2 for my report.

Hi all I have got a problem referencing some fields for a report, can anyone help solve this: Main form with 2 subforms on tabs, subfrm1 and subfrm 2. Subfrm1 has some controls which contain dates entered by the user. subfrm2 has some controls that are populated with the dates from subfrm1...

Thanks for the links RuralGuy, I will certainly be reading them closley...I have learned a very frustrating lesson today:o

I just wanted to say... what a wonderful resource this forum is, without it and the willingness to help and patience of the members and moderators to help others I would have given up looooong ago on my project. It is however becoming addictive, not a day goes by without my forum "fix" and I...

Thanks for the replys and the suggestions. I ended up using this code Private Sub MyCombo_NotInList(NewData As String, Response As Integer) On Error GoTo Err_ErrorHandler ' provide text constants to reduce text later and allow for faster execution ' due to added speed from...

thanks MStef for getting back, but I think the error lies in this portion of the SQL,have you any ideas? strSQL = "INSERT INTO tbl_CDT's([CDT_Name]) " & _ "VALUES ('" & NewData & "');"

Hi All, I'am using the following code to update a table (tbl_CDT) on a NotInList event of a cboBox (CDT) I keep getting a SQL syntax error message, can anyone help resolve the code please Private Sub CDT_NotInList(NewData As String, Response As Integer) On Error GoTo CDT_NotInList_Err...

Thanks RainMan89, what I had been doing was putting a period mark after MsgBox, idiot that I am.. my coding skill seem to non existant, god knows what I would do without this forum. Dont supose you would know a way of validating that the process has in fact been successful? many thanks for...

Hi All,:confused: need some code help again, I dont seem to be able to get the hang of message boxes!! The code below takes the path to a mdb file which is stored in a text box on my form, it then deletes an existing table -Expire-and replaces it with a new table also called Expire from the...

thanks for the advice, but I think I wont persue this method it might be a little to drastic if it goes wrong or gets into the wrong user hands.

Is it possible to delete an entire seperate database from within a database via code after an uodate procedure has been carried out on a click event of a commad button, what would the code be to acheive this if its possible??:rolleyes:

Thanks boys, removed "" and repositioned tmpFilePath works like a dream. My regards and thanks.

Can anyone help with this code please. I keep getting Error 13, type mismatch on the on click event of a Command button. Private Sub Command6_Click () Dim tmpFilePath AS String tmpFilePath = Me!Text1 DoCmd.DeleteObject acTable, "Expire" DoCmd. TransferDatabase_...

got it now after a little trial and error, & vbCrLf &

sorry,screen shot here now

Bob, heres a screen shot of your code in action! is it possible to have to lower case text on a seperate line instead of split like it is. Just for the sake of good design?