Search results

We are upgrading one of our servers, and when i simply copied the entire Access database (that has worked for years with no issues) to the new server, i get an erorr when trying to print: Run-time error '3021': No Current Record I have some code in place that runs a query to get the variable...

Using a data macro, I want to know how to print a report after the insertion of a row of data. I am able to create the macro, but there are no choices for reports on the actions. Also, I see an action for a DataMacro, however, when I create any macro, they do not show up in the list of...

I'm trying to have a page automatically print every 10 seconds when there are results. The 10 second timer is good, the report and print is good, but when I try to print it via VB, it gives the error "this action cannot be carried out while processing a form or report event" and highlights the...

I would like to create a script that runs every 10 seconds. The script would run a query looking for data in a table, if there is any data, then it prints a report based upon that data, then deletes the data. How do I go about doing this? I can write the code to look for the data, print the...

We have a need to produce hex and ascii in the same results field. The field with data will be bound to a 2D barcode (the square ones you see everywhere now). The format of the data is to look like this: [)><RS>06<GS>xyz<RS><EOT> The <RS>, <GS>, and <EOT> all need to be hex values as...

This is what the command is in Access 97 that works: "C:\Program Files\Internet Explorer\IEXPLORE.EXE""http://10.3.1.18/" It opens an internal web page to our company. The same code in Access 2007 just brings up IE to the home page, how do I get it to open in a specific web page? It must be...

I have a field that will contain information in the following format: data-data1-data2-data3 Each chunk of data will be variable in length, but they will always be seperated by the - field. I am able to get the first chunk out, and the last chunk out, but just can't wrap my brain around how...

I have a calculated sum field in the report footer of a report. I have it set for format currency with 2 decimals; however, for the number 1234.56 it displays it as $1.234.56 instead of $1,234.56. What do I need to do to have it show the comma opposed to the decimal next to the number 1?

I have a report created where the page uses a query as the back end, all works well. I need to add a text box with the summed up values; however, I keep getting the #error for the result of my sum function. I am trying to Sum up one field called SCHDQTY. On the textbox I am trying to put the...

I need to send an email based upon query results via vba or macro. Here is the steps taken: 1) user clicks a button 2) I need a query ran with the following syntax: select HighAlert from Orders where (order = 123456) 3) I need to cycle through those results (seperate order lines) and if...

How do I run an sql stored procedure in a microsoft access query? I am looking to do this because I have a macro that deletes a table and then appends it; however, since I moved the table to sql, the delete takes a very, very long time, and I think running a stored procedure on the server side...

I have a form that when a button is pressed, I wish to call a query, and, if there are any results in the query, then display the results either via pop-up or just open the query results itself (which may be easier). So, here is sort of what I need done: if this query has results: SELECT...

I am using access 2007 on a server 2003 machine. I am logged into the administrator account. I am storing the access databases in a trusted access folder. I go to a report, open it in design view, go to page set up, change it to use a specific printer, click ok, save. I go right back into...

I am able to run an access “program” which prints a report using a stored procedure, this works fine. (the "program" is just a .bat file which calls an access database that has an AutoExec macro which sets warnings off, opens a form. On the open form event, it prints a report, closes the form...

I wish to output a report to a file. I wish the file to be a word document, saved in the same place everytime, and with the same name everytime. i also wish to overwrite the current file that would be in the folder automatically. The report name is INVOICE - E-INVOICE-A. How would I go about...

I am trying to put a value into a variable from an sql statement, and I am getting an error...here is my code which is way wrong: Function PrintPackSlip() Dim strPackSlip As String strPackSlip = "SELECT PackSlip FROM InvoicePackSlipPrint" DoCmd.OpenReport strPackSlip...

I have the following query which basically is an instert into a table with a select statemet insde if...here it is: [code] INSERT INTO

I have recently done a fresh install of access 97 to our 2003 server. I load up an access app, it brings up a form with a button...I clidk the button, and it closes the app with no errors, and leaves the ldb file in tact. Checking the event viewer, I get this message: Faulting application...

I have a subform inside of a form. For that subform, on its focus, I wish to run some code. I want the code to run a query: SELECT ORDERS.SPL_HNDL AS SplHandling, ORDERS.[ORDER #] AS OrderNum, ORDERS.[CUSTOMER #] AS CustNum FROM ORDERS WHERE (((ORDERS.[ORDER #])=[Forms]![ORDERS INPUT...

We are using access 97 and I have a linked table to sql 2000. A couple of weeks ago, our sql server crashed and we had to completely rebuild it / restore all of the data. Ever since then, only one of our linked sql tables in access is acting up. Whenever we go to edit a line (sometimes, not...