Search results for query: *

Gives an error: Wrong number of arguements used with function in query Concatenate("SELECT [Occupexposurelimits] FROM allergentype WHERE Formkey= """ & [Formkey] & """", " ")

Thanks, The function is giving me a result! The problem is the result is not correct. I need the result to have formkey and a single value of the child records (allergentype). The resulting string is the only the first record of formkey. Example of allergentype: Formkey Itemkey...

Hi Folks, I have a function that is giving a Run Time Error 3061 Too Few Parameters. Following is the Function: Function Concatenate(pstrSQL As String) Dim db As DAO.Database Dim rs As DAO.Recordset Set db = CurrentDb Set rs = db.OpenRecordset(pstrSQL) Dim strConcat...

I have a table that has to give the exposure limits of a parent item. The child items determine the exposure limits based upon another table. So it works like this Parent item no. has a exposure code 1234 Child item no1: exposure code 1 Child item no2: exposure code 2 Child item no3...

Error exactly: The expression on open you entered as event property setting produced the following error: Error accessing file. Network connection may have been lost *The expression may not result in the name of the macro, the names of the user-defined function or [Event Procedure]. *There may...

In generic terms it says it cannot find the file. I'm not sure what file it is looking for.

Yes I can open the form in design view, but when I try open the event that runs when the form opens I receive a network error. I started this developmental database from a copy of the current, so all the underlying recordsets are present. I kept track of all form changes and double checked by...

I have a current database that I want to copy some forms and macros into from a developmental database. What is the best method? I have tried exporting the forms and the macros, but when I try and open in the current database the form won't open. Also I cannot just overwrite the current...

We recently converted from access 97 to access 2000. A number of queries and reports used a format function. I've attached an example. Can someone explain why the format function doesn't work and the appropriate syntax I should use. Thanks in advance...

Sorry forgot to attach the code portion Private Sub BUTSAVE_Click() On Error GoTo errSect Dim stAction As String Dim lnerr As Double stAction = "Main.ButSave" lnerr = 1 Dim stMsg As String Dim insub As Integer Dim stdb As String Dim inOpen As Integer...

We recently converted databases from Access 97 to Access 2000. I'm working in someone else's code and I'm not sure the following code is working. The following code is suppose to update a table called Maint297. When the code runs it doesn't seem to work. There is no error so I don't have a...

We just converted all our access databases from access97 to access 2000. Now I can't get a query to run from a criteria based upon a date field. Previously if you wanted a date greater than 1/1/2006 you just put >#1/1/2006# in the criteria grid of the query. Any help would be appreciated. Thanks

I had to convert a number of databases from access97 to access 2000 and I have a problem with the following code running from a form when a buttton is clicked. First I get an Error in Alpha1.FormBU Overflow then I get an Alpha1.Append 1/1 Index or primary key cannot contain Null Value. This...

The fields that have to be unique are the cust_key and the ship_to_key. This table represents every ship to location for every customer number. So there won't be multiple addresses, but other customers might have the same ship to location. The Ship_to_key field is only 3 characters long so...

I have a query that is appending new records to another table, the problem is that for unique records I need to assign a unique number to a field. I have figured out that I can get the last number using DMAX, and I just want to add 1 number for record that I am adding. The field is a...

I'm trying to open a web address from a run command in a macro, but doesn't seem to work, I can open explorer but that just takes me to my home page.

The Alter Column is not a valid syntax with my version of Access 97. Thanks

I have a make table query that makes a fieldsize that is too large. I only need a property of 10 and it is making the size 255. It is causing problems with reports and indexes. How can I change the fieldsize property within a query or macro or code? Thanks

I'm using a query to append the data.

I never had PFD 4.6, Try this web site. http://support.bestsoftwareinc.com/pfw/