Search results

After his first reading of it, someone gave him a different version, containing passages about Jesus, etc. as opposed to the yellow one listing pizza delivery, carpenters, etc. that he had just finished?

There's a comma after VehNo.

I was unable to type into the box, as you mentioned. However, when I deleted it and recreated an identical textbox (same data source, same settings, etc.), by copying pasting one of the other fields, it worked fine. Perhaps this is an option for you?

Jilly, the zip file contains a shortcut, rather than the mdb file.

Apparently, 'effective against bunions[sic]'.

Received, thanks. Either I got the day wrong, or it's being repeated here on the Saturday.

Okay, it’s back to this problem - until the powers that be decide otherwise, that is. Hopefully, the posted ‘cut down and doctored’ version of the db will give you the gist of the problem(s). In summary, when everything works: 1) Select a record from the topmost, left list. 2) The rest of...

*phew* Glad that one finally got sorted for you. :D If you get the time to do so, Gemma was definitely right about creating a function. I didn't mention it before, as the initial problem only involved a few letters, so it didn't seem worthwhile. Now that - theoretically, at least - you could...

Could you use something like Dim li_AI_Count as Integer li_A1_Count = DCount("*","tablename","Family = 'A1') using the name of the table from which you're fetching the Family data. Then assign this value to a field on your main form? If so, you could repeat it for A2 and C3.

Nothing immediately springs to mind. I have had something similar happen to me, when a field just would not allow me to update it. In that case there was something 'corrupt', for want of a better word, about the control itself. I was able to fix it by deleting the control from the form and...

Okay, so we know the overall string is being produced correctly. Process of elimination time: We add a few more Message Boxes and see at which point the code is going wrong. Dim str_Overall As String Dim str_H As String Dim str_A As String Dim str_L As String Dim str_E As String Dim str_S As...