Search results

Hi TimW, Is it possible to give me an idea of what the fields are in your initial BOM file with some dummy data. I am confused as what is the difference between the fields "Quantity" and "Units". Also what is a "LevelTotal" I assume it is the number of records at this assembly or subassembly...

G'day I am not sure where to log this request. :confused: I have 3 tables. a table of customer orders A table of preconfigured Assemblies with a bill of materials (or Components) A table of components which can be ordered individually and they may also be part of an preconfigured assembly...

Hi MarkK, It works perfectly. Many thanks. I owe you a beer when next you are in Australia

Hi MarkK, I don't seem to be able to find the timer event unless I look at the events for the whole form. I really want to set the timer when I click the field in the record. Can you give the code snippet to do this please? Cheers, HB

Re: Mouse clicks on a form G'day MarkK, That's for the suggestion. It makes sense to me. I'll give it a try and let you know. Cheers

Hi Ranman, You are correct the Title should be "mouse clicks on a form" I have a parts ordered list as you suggested on a form called FrmOrder. At the present moment a single click on an item opens a form called FormA that allows me to select new items to add to the parts ordered list...

G'day, I am in need of some help please. I have a parts order form (FrmORDER)with a list of parts selected stored in it. e.g Part #, Part Description, Qty, Price etc I also have assemblies stored with the same detail that are composed of individual parts. What I would like to do is open...

G'day, Every time I try to down load the mdb file you have attached to the repository I get the following errors. It appears as though it is trying to download a .php file instead of the .mdb file I am also getting the same problem with other mdb file examples on this site. Is there a reason...

Hi All, Problem solved. I found a solution at the following location. http://www.lebans.com/rownumber.htm :D

Hi thanks for your help. It is the sequence number of the tasks. Refer to attachments in my reply to SMIG Thanks in advance for any help you can offer

The attached may better explain what I am trying to achieve. Attachment 1 shows the records prior to deleting any records. Attachment 2 shows what happens when I delete the 3rd record in the sequence. As you can see when I delete a record in the SubProcSteps form I want to renumber the substep...

G'day, I have a table with entries describing a sequence of Tasks (tblTask) tskID TaskDescription 10 Clean Room 12 Wash Dishes etc I have second table called Steps (tblSteps) that is related to tblTask via the field "StepNumber" which is a concatenation of [tskID] & "." & [StepOrder] So if we...

Hi JDRAW, Your feedback was good, however perhaps I was asking the wrong question. I have solved my problem using this example. http://www.fmsinc.com/microsoftaccess/forms/synchronize/linkedsubforms.asp Cheers

G'day, If your record count is increasing at the bottom left of the screen when you enter a new record then as you say the record is being written to the table. When you interrogate the table to display the records for the form are you sorting the records in the table by some field say...

G'day, I have a dbase with 5 tables N_Customers, N_Orders, N_Products, N_Timequoted and Employees. I am trying to build a form showing Customer Name, a subform1 with list of Orders and then for each order a subform "Products" with the list of the parts used and finally subform3 "Labour" with the...

Wow thanks ever so much. Some reading for tomorrow. It's 2:00am here so I'm off to bed. Once again thanks heaps. Cheers

Hi Gina, I went and checked and found that one of the SQL tables (tblTimesheets) did not have a primary key set. As a result I could not add records to the table in the SQL database. Also it would not let me assign a primary key as there were duplicate records. Further investigation resulted in...

G'day, I am running access 2007 in Win7. I have a time sheet application that I wrote many years ago. Within same I have a button to press to open a new form to enter time sheet data. The data for the form comes from a query that links Employee and the Timesheet history data file. In an effort...

Hi Dave, Yes that seems to work ok. Many thanks. I am trying to get my head around recordset clone and was attempting to use the following VBA code that I obtained from the web. ____________________________________________________ Option Compare Database Sub BookmarkX()...

G'day, I am trying to create an ODBC link to a copy of the Northwind data base. I am running Win7 on a 64 bit operating system but am keeping office running as 32 bit for Access, Excel , Visio etc due to the fact that I have a lot of old apps tied to them. When I attempted initially to...