Search results for query: *

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...

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...

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...

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.

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 have a table that has records that already have unique numbers. I'm appending new records in from another table, but I'm trouble with an indexed field that needs to have an unique number, I need to take the max number from a certain record set,(ie. any record that has a sysid of M), that...

I have a form that I use to copy records and then change a few fields to create a new record. A few fields do not copy one of them is a primary index key. When I try and save the record it gives me an error null primary key error. Do I have to have the field on my form for it to copy...

I need to look up the files in a directory from a subform and then after selecting pull that file name and extention into the subform field that is currently active.

I want the program that is called in the code below to have the focus in maximized window. It works on NT 4.0, but on Win 2000 it goes minimized to the task bar. Thanks here's the code. vall2 = """C:\program files\Lmw32\lmwprint.exe"" /L=f:\labels\&quot...

I want to pass the text from an unbound text field to a program that access runs when a button is pushed. I've attached the code that calls the program. I've tried using the send keys but the program takes a few seconds to start and I don't know if I need to pause. I've seen this done, but...

I want the program that is called in the code below to have the focus in maximized window. It works on NT 4.0, but on Win 2000 it goes minimized to the task bar. Thanks here's the code. Dim Msg2, Style2, Title2, Help2, Ctxt2, Response2, MyString2 'Ask for label 2 Msg2 = "Do you...

I am trying to decide between putting in a Static IP DSL or a DHCP DSL. Our Novell network already acts as a DHCP Server on our network, and I have had a DHCP DSL Router before, so I know this works, but I want to be able to come in over the internet and either log in as a workstation or take...

I'm getting a Buffer Length Error when I try and print preview a report. I just upgraded from Crystal Reports 6.5 to 7.0, I've tried saving the report in the new format, I've tried reattaching databases, I've tried using updated ddf's(Btrieve). Some of the reports work fine, others give the...

I have a append query that when it runs I get a "ODBC call failed error", when I click ok I get another screen that says "ODBC Interface[ODBC Engine] The data type is invalid for the expression" . I just put on a new patch for the ODBC Engine, but I can't track down which...

Should I upgrade from Access97 to 2000? What are the downsides? I'm afraid of alot of reprograming when previously developed programs won't work any more. What new features will I gain by upgrading? Thanks for the input