Search results for query: *

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

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

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

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

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

If I start with a list of number such as this; 503422932 503422937 503422938 503422939 503422942 503422967 503423013 503423014 I would like to have the output look like this 503422932,37,38,39,42,67 503423013,14

Background: I have a Database we have used for 12 years. Access 2003 (Access 2000 file format). The user opens a form it show open invoices we owe to a customer. It is a continuous form. Only one control is available to the user in the Detail. CheckNum, it corresponds to TxtChkNumber in the...

I want to use the following code in a text box on a continuous Form. If [TxtBillComm4] ="NORMAL" Then [CurTotalPay] = [CurRate]+[CurFee] ElseIf [TxtBillComm4] = "SPECIAL" Then [CurTotalPay] = [CurRate] ElseIf [TxtBillComm4] = "NO BASE" Then [CurTotalPay] = [CurRate] ElseIf...

I have a table. It has a comments field in it. This has been used to keep email addresses in it. Unfortunately it has also been used to keep other information. (phone numbers, contact names, general notes). Is there a way to extract the email addresses without doing a manual C&P? With the email...

I have two tables. They both contain the field "InvoiceNumber". Table A has 1 record for "InvoiceNumber". Table B has multiple records for "InvoiceNumber". Both also have an "Amount" field and a "Quantity" field. I am trying to compare the "Amount" and "Quantity" fields for the matching records...

I would like to have a button on each line of a continuous form that will open a single form for the OrderID (text field) for that line. Is this possible? Essentially I want to see a list of items and if someone is inquiring about one of them be able to click the button to get the rest of the...

I am using a Win 8 desktop as a server. It's been setup and working fine for 6 months. All the workstations are running Win 7. I had the scanner hooked to an old XP machine and decided to move it to the server machine. Now when I scan to the same folder as before it doesn't show up in windows...

I have a report I use to print on a dot matrix printer. The multipart form we use in the printer is 8.5 x 7. I setup the paper size in the printer setup. We've used it to print a single form for years no problem everything lines up fine. If I try to use it to print multiple forms at one time it...

I have read several threads that look way over complicated for what I am attempting to do. I would like to store images (pdfs mostly) in a folder that will have a name that corresponds to a text field in my database. I want to place a button on the form that will open Windows Explorer in the...

I am looking for ideas for a computer based fax. We currently use a fax machine with <gasp> paper. There are so many different ways to go out there. Ultimately I want to "fax" without having to print it out first and I want to receive them in digital format (pdf?) to be stored on a server. I...

I have two tables; Carriers SafetyData IF Carriers.USDOT MATCHES SafetyData.DotNumber I want the DRSEA Field (in Carriers Table) to update to the DSEA field (from SafetyData). I am not SQL Literate and use the Query grid to make the queries I need. I was attempting this using the "Update"...

I am using a spreadsheet that was sent to me. I use the Data -->Sort function I then select sort by Load ID, Ascending, and no other selections. It returns the items ordered as follows; 58228 58289 58355 58404 58489 58514 58541 58566 58611 58635 58683 58688 58857 56815 58214 58214 58221 58221...