Search results

Error 3197 says"you are trying to update a database which is currently being updated bu another user". I am the only user and the db is on my desktop. Can somebody help please?

Hello Experts. Sorry I had to deal with urgent matters and the help file was pushed to background. Thanks to all who helped I will try one of the suggestions. If problems I will get back to here.

Hi Experts, I need to produce a context sensitive help system for an access vba application that I have written. The required user guide is written in word. When the user needs help on a certain control he should be bale to keep the mouse cursor on the control and press F1 and gets help. The...

Thanks it works in its present format, it was a logic problem. There was no syntax error, the "AND"s should have been "OR"s. That was why it was saying application error. I should have thought about it before. Sorry to bother.

Hi Ranman, That does not work either. Here ForName is a variable that contains the form's name it is not the name itself.

Hello Experts, Please could anyone tell me what is wrong with the code below. It throws an error of application: If (Not IsNull(Forms(ForName).F03)) And (Forms(ForName).F03 <> "") _ And (Not IsNull(Forms(ForName).V03)) And (Forms(ForName).V03 <> "") Then This code is in a module called by...

Re: date variables sql SOLVED Sorry for late response. I am on multiple projects. In the meantime I found the solution. Posted below. The code is inserted in a module for other forms to call when necessary: If Not IsNull(Forms(ForName).F04) Then sWhere = sWhere & " and " & Forms(ForName).F04 &...

Hello thanks for the response. But it does not work. It says missing operator. Also additional info the date field name is obtained from a combobox which changes with every query. I need to display the actual query sql each time. This is educational software.

Hi, Could please anyone tell me what is wrong with the code below? If Not IsNull(F03) Then sWhere = sWhere & " and " & F03 >= " & " 'Format(V03, ''#dd/mm/yyyy#'')'" & Chr(13) It says missing operator. F03 is date variable and v03 is a date value. Thanks.

Your code is easy to implement and it works. The problem is that in my case I am getting the names of the control fields from combo boxes that have fields lists of tables and/or queries as rowsource. So I need to display and use the name of the control field that changes in every query. How do I...

Hello Experts, I am trying to write an application where there is a query form and a results form. The query form accepts two text fields and values and one date field with two values with GE and LE operators. The search values can contain the null values. It is a pretty complicated job. Does...

Very useful info. Solved the problem. Thanks.

Hello Experts, I have a combobox called CountryBx on a form. The RowSource is a table called CountryCodesTbl. CountryBx has two columns. The first column is bound to the CountryCodesTbl table. There are no column headers. When the form is loaded the combo should be blanc. When the user hits the...

Re: Run query without a form [SOLVED} Thanks to All who contributed in the discussion. In the end I figured out my solution which is a combination of various techniques proposed. I created an action query to drop and recreate a temporary table. The source data of this table is coming from the...

So what you are saying is I have to use a form, if necessary in hidden format, to execute a SELECT query. Otherwise it is not possible to run a query using for example the DoCmd command. Indeed, I was thinking in the same direction. My only point was perhaps there is a way out and only the...

No I do not have an input box before the query. The query itself should prompt for the input. That is I consider it this way. There is a main menu with a button on it. When I hit the button this select query is fired. The query itself asks for input of the sterm by displaying a pop-up box. The...

Thanks. It runs the query but does not prompt to get the input called sterm from the user. What should I do to have this prompt?

I tried db.Execute "SelQy" DoCmd.RunSQL SQLStatement They both do not work.

I have a select query which has an input parameter in the where clause. I want to run this query and use the results as a recordset. I have already set the create query definition object. How can I run this query without using a hidden form.Here is the preparation part of the code Sub...

SOLVED Thanks a lot for the help. Sorry I could not get back sooner. I have solved the problem in a similar way by storing the result of the split function in an array.