Recent content by weavind

Just wanted to say thanks. Got it working now. :) Below code works 100% Set rst = Me.subfrmStockInfo.Form.Recordset Me!subfrmStockInfo.SetFocus Me!subfrmStockInfo.Form!txtSRN.SetFocus rst.FindFirst "SRN = " & Form_frmStockInfo.cboSRN Set rst = Nothing

When i change the recordset to Set rs= me.subfrmStockInfo.form.recordset, then the subform just changes to #name when i enter a stocknumber. However if i put the DoCmd.GoToRecord acDataForm, "SRN", acGoTo, rst.AbsolutePosition + 1 line in, then i do notice that the subform now jumps to the...

Hi, I have a main form and a subform which both have show records from the same stocklist table. The main form has a summary of one record while the subform is unlinked and shows a list view of all records. On the main form i have an unbound control box that a stock number can be typed into...

The code below works - thank you. :)

I’m not sure how to word this, but I want to use the UNION SELECT command to join two tables together and then link another table to this joined query. I have two invoice tables (InvoiceCompanyA & InvoiceCompanyB) which are identically setup. I then have a InvoiceDetail which lists all the...

Thanks, you made it so easy. Works prefectly now!

Thanks JR, That works fine. Can you show me how to call this value in a report?

I have an Invoices form (frmInvoices) which has a sub form linked to it (subfrmInvoiceDetails). These get their data from the two tables, tblInvoice and tblInvoiceDetail. Basically, I would like to take the subtotal of the subform and write that value to the main form (value to be stored in...

Thanks Doc Man. With your help, I found the problem. It is the references that is the problem, however it is to do with Office 2003 and 2007. I compiled the database on my notebook which has Office 2003 and 2007. The main users only have Office 2003. When I compiled the database, it looks...

HI, I have a table that I have a date field with "Date()" as the default value. The tables sits on a linux server. The frontend is copied to each workstation. The forms that access this table works perfectly fine on my computer (Win7) and notebook (WinXP), but on some workstations, the field...

Fantatastic! Exactly what I needed. I'm going to try the code now. Thank you!

HI, I would like to know if there is a way to have a form (checkbox or similar) select which table to use. My problem is that I am trying to add invoicing to my database, but the database has two companies linked to it. The invoices for company_1 is stored in table_A and the invoices for...

Hi, I am trying to sum up a list of invoiced items (data stored in table tblInvoiceDetail) and write this value to the “Total” field in the table tblInvoices. I want this to update after each record is typed in the subform. I was given the below code from friend, but neither of us can get it...

HI. I got the script working. The .requery worked. However only when I compile the database on a XP computer and use the mde file on a windows 7 pc. If I work on the mdb file on a windows 7 PC, then I get all kinds of problems. I think it could be that i'm still using a 97-2003 database...

Hi, I have a filter sub that has worked perfectly fine in Windows XP, but will not work when used in Windows 7. The database is in 2003 format. Basically, I have a text box in the form header (frmStockInfo). When you type in a keyword and press enter, it searches the table "tblStocklist"...