Search results for query: *

I tried to recreate it and I can't get it to happen again, after I correct the error.

I haven't decompiled and compiled before. When I do I get an error in a module which I fixed. I also have 2 reports (that were converted to reports from a form) and 1 form that open. Is this telling me I have an error in those forms \ reports? If so, how do I determine where the error is? Thanks

Yes each machine has a copy of the front end for both databases.

I have 2 databases. 1 (Database A) was created in Access 2000 and has been in use about 18 years with no issues. The other (Database B) was created about 1.5 years ago in 2003. Both have been converted to Access 365 databases. Both have a front end and a backend. Both are used by max 5 users at...

For instance, setup the table with a MEMO field and then each paragraph could be a separate record in the table? I believe I can handle this. Thanks Duane!

Access 2003 I have a 12 page contract currently in Word. I only used data from 2 fields in a query in this report. The rest is static text. I currently mail merge to Word to print it out. I would like it to be a report in Access to make it a more seamless user experience. I am not sure what...

Sorry for the late response. I did resolve the issue. It was caused by the newer versions of the Office apps installed in the machine from the factory. I uninstalled these apps and it works perfectly again.

Office 2003. I have a .mdb I run the front end on multiple computers. It's over a decade old. We recently had a computer go down. After I installed Office 2003 and copied the file to the new computer, It give errors related to the events. (on current, on click). I believe this is related to how...

I was able to just delete the #error fields and export the rest to a fresh table. Thanks for all you help!

The database has been in operation since 2004. It's corruption. A new adventure for me. Not sure what is causing it. I recently built a second database. It uses (as in links to) a couple of the tables in the original database that is having the issues now. Is this possibly a cause? I did it...

It also says this recordset is not updateable.

I was having some issues with errors in my database and performed a repair and compact on it. I then began getting some errors with regularly uses routines. They seem to be focused on a form that opens up on top of another form. The first was in the macro it saves the record. It states record...

awesome thanks!

I can't try it right now but just curious can I also use Where Int([Your Date Field]) = date() to return the records that have the current date?

Thanks. Evidently I have never used a date with a time component in the same field.

I have dates formatted as general date. Input mask in forms is 99/99/0000\ 00:00;0;_ When I try to query these dates using #02/18/2018# nothing results. If I use a between with the previous day and next day it will work. What am I doing incorrectly?

I'll take a look at this thanks.

I use the following code to export to an excel spread sheet to upload. I need the first line to be deleted on the excel sheet. It has the field names on it and the place I upload needs only the data. I have searched but am unable to find a solution. OR the alternate is to prevent it from being...

I use the following code to export a Query to Excel 2003 Dim strQryName As String, strXLFile As String, strName As String strQryName = "QryBillingMailMerge" strXLFile = "F:\weeklybilling.xls" DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel97, strQryName, strXLFile FollowHyperlink...

Thanks! I will give this a shot.