Search results

Thanks for replying arnelgp. Have modified my code slightly as per your suggestion and it seems to work. Need to test further, but thanks for the suggestion. The speech marks could be the way forward:- "" = Me.txtFld1 & "" :)

Which means that I need to insert a bunch of IF statements to test both fields for null. Thanks for the explanation gemma-the-husky. :)

Hi all, Before saving a record, I am testing 12 form fields for duplicates against all records in a table. However, I have an issue whereby if the table field is null and the text field on the form is null, it doesn't recognise this as being equal. This is the line in question:-...

And spikepl, I did provide the error message which appeared and not the mis-quoted "doesn't work". I also provided the snippets of code I used which produced the error. And if you ever do find the cure for "unhappiness", please let us know. ;)

Hi JohnHBooth, Yes that's it: FORMS!FORM1.Controls.Item(myControlName) = myList Slight tweak with a full-stop before "Controls" rather than exclamations mark. Thanks very much to you and everyone else that replied. Kind regards.

Thanks for your replies Ranman256 and spikepl, but neither work unfortunately. gemma-the-husky: You've explained it 100 times better than me and that's exactly the problem: "so you are reading the value of a textbox, which is the name of another control, and then trying to assign a value to...

Hi all, Hopefully, I can make myself understood on this one. Seems simple enough, but I just cannot work it out. I have one line of code which reads:- myControlName = [FORMS]![FORM1]![txt_myControlName] Text field txt_myControlName stores the name value of another text box on that form (this...

Thanks for the reply Ranman256. The string is being created from different fields on a form. Will your method still work in this case? Thanks.

Hi all, I'm using an INSERT INTO query (in a standard VBA module) and one of the fields in the underlying table is set to MEMO. Query runs okay, but only the first 255 characters are inserted. When I Debug.Print to the Immediate Window, all 423 characters are displayed correctly. Please...

Thanks for the reply Ranman256. - Yes, the table in Access has a memo field - I am importing it manually using GET EXTERNAL DATA > EXCEL etc (it's a one-off) - If the field in Excel has 524 characters, it imports only the first 255 characters. - If I copy the data from Excel and paste into...

Hi, There is a resolution to this already, but was wondering if there is an alternative method. I have several records in an Excel file which can contain fields of over 255 characters. Therefore, I set up the Access table field as "memo-type". Before importing, I need to create 10 or so...

That's awesome namliam! Thanks very much for your quick reply. :)

Hi All, I've been using the DateAdd function to great effect, but am stumped on a solution for this problem. I have a table full of dates which run in sequence, i.e. 1/9/15, 2/9/15, 3/9/15 and so on. I require a query to show me dates for just every two weeks starting from the 1/9/15, i.e...

Thanks for the reply arnelgp. Looks like VBA is the route to go. I did figure out how to do it in the QBE, but there are complications when trying to validate many fields on a form. Can I ask one more question please. I'm trying to add a variable text field name into the code, but can't get...

Good afternoon, I have a saved update query (created from the QBE editor) which takes the values from unbound text fields on a form and updates an underlying table. However, if a text field is left blank, it overwrites any existing data in the table for that particular field with blank data -...

Thanks for your replies. I've gone for a loop at the end which seems to do the trick:- Thanks for your input people. :)

Sorry I didn't explain myself in the first place. Yeah, I'd sort of gathered that it would be the case re: speed of code execution. How/where could I place a half-a-second pause within this code? Thanks again.

Thanks for replying pr2-eugin. I'm wanting the label to be visible before the "for each" calculation takes place (the label has a caption of '...refreshing'), then dissapear when complete. Cheers.

Hi there, I have the following piece of code on a command button on a form: The label is not visible when I execute the code via command button. However, if I step through the code, the label works like a charm. I've added Me.Repaint, DoEvents etc, but to no avail. Could it be that the code...

Many thanks.