Search results

Thanks everybody, AncientOne, your advice worked a treat. Thanks again Mark

Thanks for your reply, I have dumped the kbrackets and still no joy. The SAC_SOrg_Temp.Period field is a text field. Thanks Mark

Hello to anybody who can help, I am trying to update a table by using the code below, i know that it works without the criteria but as soon as i use the 'Where' things go wrong. I currently get a type mismatch failure, if i change the = to like it runs without error but does not update the...

Hi, have you tried using me![network data info source].setfocus Hope this helps Mark

I have a list box and I want to set the record source within VBA using SQL. I have a query and its SQL code, what I would like to know is if the SQL code I have got can be used as I would like or if it cannot, what can I do to change this? Thanks to anyone who can help. The code is as follows...

Thanks to both of you for your help, I moved the code into a seperate module and called it from the main form and then the popup and found that the code did not work when called from the popup form. I have rectified the code and everything is now o.k. thanks again Mark

Thanks Axa, but it still doesn't work. I have tried calling the procedure a number of different ways but it either does nothing or brings up an error message depending on which way I try and call it.

Hello, I have a form with a command button on it which requeries a load of controls on my form. I also have a popup form which I open from the main form, this popup form contains a list box. My problem is that I would like to call the command46_click (main form) procedure when I click on the...

Because I would like them to be null and then populated by information when everything has requeried. If there is nothing to find I want the fields empty rather than populated by the previous selection.

Hi, I have a pop up form which contains a list box. When I click on the list box it populates a text box on the main form and sets other boxes to "". My problem is that i cannot get the controls on the list box to requery the text box each time I select a different record from the list...

Thanks for your help aswell Doug Mark

Thanks Drew Everything works great! Keep up the good work! Mark

Hi again Drew, Thanks for this, it works perfectly. But I have one more question. How do I get it to check for double spaces and replace them with a single space? Thanks and sorry to bother you again Mark

Hi Drew It came back with the subscript out of range again. Maybe it is something I am doing wrong I will try again in the morning Thanks Mark

Hi Drew, I just tried it and it came back with a runtime error 9 Subscript out of range I have to go now but I will try anything else in the morning. Thanks again Just a straight replace with a space is fine. I am just going to try it now. Mark Mark [This message has been edited by...

Hi Drew I clicked on the definition but it did not bring any code up. If you could help I would be very grateful, if not thanks for trying anyway. Mark

Hi Drew, sorry but this is all i have. This is what i thought initially but as i don't know much VB i just thought he knew better. Thanks Mark

Here is my problem:- I need a function to check for unwanted characters in a field (for example ("," " ",""") and then replace them with a single space. I think I have found a piece of code from an old employee which was designed for this purpose, but being a total beginner I do not understand...

Can anybody help? I am trying to preview a report but when I click on the button it comes up with Runtime Error 7794, the tool bar "CSprint" is not available. I have other reports that preview fine and cannot find any information about what could be causing this. Thanks to anybody that helps.

Thanks David for your help