Search results for query: *

I'm creating a report that shows trial balance from a query. I take the beginning balance + transactions, and in my detail report area I create a field called TxtEndingBalance. In the report total, I'm creating a text box to add up all the balances in the TxtEndingBalance fields. My problem...

I have a file in dBase that is a temporary file. I want to delete the items in that file (Zap it) with Access 2003 VBA code, then I want to add new items to the temp file. It really isn't difficult to do, but the problem is that when I bring up the temp file in dbase, the deleted items still...

I am more curious about this than anything, because most indexing and sorting is done through queries, but in Excel you can sort a range by a primary and secondary field. Can you have a primary and secondayr sort field when you view an Access table or can you only sort one field at a time?

I have two recordsets which represent tables - rsmaster and rsship. the recordset rsship refers to a table (tblship) which may or may not contain a ship to address for a customer that is different from the ship to address in rsmaster. If there is a record present in tblship, I want to transfer...

This is very frustrating. I'm trying to undo changes to an unbound text box. Just to test this out, I have created a text box (txttest). I have created a simple BeforeUpdate event that does the following: cancel = true me.txtest.undo After I change the entry in the text box and press the...

I am trying to format a report to print two W2 forms per page on the preprinted W2 forms. The top of each W2 is at 3/4" and 6 1/4" on each page, and each W2 form is half a page. How do I go to a new page after every other record (two records per page)?

I have users that want to continue to use dbase IV programs and Access users that want to use (and add and change) the same dbase files (tables). Is there a way that both the dbase users and Access users can use, update, add and lock the same dbase files so that each program will detect and...

Is there a built in function in Access that will give the last keystroke pressed? I know there are key down and key press events, but I was wondering if there was a built-in function that you could use anywhere in code. dBase had a function called LASTKEY() which would always return the last...

I have a combobox to look up a customer name from the last name and first name (lname,fname). The data tables are located on a network. I have set the rowsource to the datatable TBLMASTER, which has about 56,000 records. The combobox is ordered by lname and fname. When I start typing the...

I have an invoice form (frminvoicedetail) that contains a subform (frminvoiceDetailSubform) based on a table (tbltempdet). Each row in the table is a separate line on the invoice. One of the table's fields is called ORDR, which is the order the rows will be printed on the invoice. When the...

I have an invoice form with a subform that contains the detail lines of parts ordered (from table tbldetail). In the main form I add a new part number to the invoice, which is then subjected to edit tests, then added to tbldetail. The problem I have is that I would like to have the subform...

I have an invoice report (rptinvoice) that prints from a query (qryinvoice). The query specifies invoice lines from a table and is sorted by an invoice line order (called ordr). When I print the invoice (rptinvoice) from the query, the invoice is printed in the natural table order (unsorted)...

I have a form that creates records in a temporary table in an invoice (tbltemporary). When I accept the invoice I want to add all the fields from all the records from the temporary table to the permanent invoice table (tblinvoice). I'm thinking I should use the Insert Into command from runsql...

I am running a form with several related forms. To save time, I would like to load the related forms when loading the initial form. A problem that I am having is that when I load the related forms are loaded it triggers the related form's on_activate event even though I don't want to run it...

Is there a way to refer to a variable that was created in another form that is open? Say variable "VAR" was created in form1. If I am in form2, how would I find the value of VAR? Something like? a = forms!form1.var Thanks.

This is probably extremely simple but I just can't get it. I would like to have my VBA code select an option button in an option group based on the value of a text variable. I don't want the user to have to click the option button, but I would like the user to see that the button has been...

I have a form with a subform that is linked to a table (tbltempdet). I would like to have the user click a line (record) in the subform, then find out what record the user clicked. The navigation buttons show the record number, but I would like to capture it in code because I need to perform...

I am using a preprinted invoice form. Each invoice has a different number of detail line items, then a section at the bottom for summary and shipping information that I would like to put into a report footer. I know that normally the report footer starts to print just below where the detail...

I have a report that prints an invoice. It is based on a query that has several tables, but the problem lies with the following two tables: tblinvoice and tblship (tblship is a table which contains a ship to address that is different from the billing address). Not all invoices have a separate...

I am trying to declare an array as public so that various subs on a form can use it. However, when I enter something like: Public ARR(4,4) as variant in the declaration section of the form's code, then try to assign a value to one of the array's items, I get an error message: ...Constants...