Search results for query: *

Is there a maximum file length on importing an external file into access, I am having trouble defining fields after 500 charachters, is this a limit in access?

Try checking the references in the database, You may have to change the reference to word to the older version. I can't try this because my PC is not set up the same as yours. Hope it helps Phil

Another thing to keep an eye on is any "Make Table" queries that you may be using, especially as the source for reports. Each time this process is run it expands the size of the database. Even though in many of these processes, "temp" tables are deleted, the database still...

TBrowne, Our Agency ran into the same issue a while back, we came up with some code that kind of fools outlook but is not reliable. What we ended up doing was designating a specific PC and user ID to run the process. We did not install the security patch on that machine, we also set it up to...

Bastien, I've checked the references and there are no conflicts, I tried using different DAO references but none work. Phil

I have an Access 97 Database (FE) that has a 97 (BE) on a server. In the database there is a procedure that tra sfers the results of a query to a text file (in a designated folder on the server) for a mail merge. DoCmd.TransferText acExportMerge, , "qryACK&quot...

I just got a new computer that came loaded w/ Office XP. Our Department is running Office 2000 and 97. I have created a database in Access 2000 format, but am unable to create a 2000 MDE file. Is there any way to do this without converting to Access 2002 first. If not is my only option to...

There are some good tools at http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnsql7/html/access2sql.asp to help convert Queries to SQL Server. Hope this helps. Phil

You could add the access db as a scheduled task, and create an autoexec macro to lauch code to do the import of the data and then close the db.

Try using the update this way UPDATE tbl_Customers set CustomerTitle = @CustomerTitle ,CustomerFirstName = @CustomerFirstName , etc.... WHERE CustomerID = @CustomerID Phil

On the double click event of the Datefield.txt just CalControlName.visible = true Then input this code on the form where the cal.control and the date field are. This will populate the Datefield.txt with the CalControlName value when you double click on a date on the calender control. Give it...

Cal Controls can be found under More Controls on the Toolbox Toolbar

Yes, you can by using the Active X Calendar Controls. What I've done in the past is have a Text Box which will hold the date field. And on the form have a calendar control (an actual calendar) that is not visible. I make the user double click in the text box,and on that event I make the...

Try this... CSearch = CSearch + "AimDescription like """ & _ ("*" & mmAimDescription& "*") & """"

What does the SQL Script behind the query look like? That should help you write the VB Code.

"[ItemType" & [forms]![formname]![numberfield] & "]" would this work?

You can create a form with a combobox or listbox that has the values for them to select from, then pass the value from that field into the query criteria. Phil

What does the overflow message refer to? Phil

I'd suggest on the afterUpdate event for the year field if you put some code to open a recordset that contains members for the selected year and check the number of records, and if = 0 then display a message box indicating no records for the particular year and exit. Hope this helps. Phil

IS your combo box named WorkerName and is your text box named WorkerID? If so, when you click on afterupdate event select the (...) at the end of the line, then select "code builder", then under "Private Sub WorkerName_AfterUpdate()" input the text: WorkerID=...