Search results

I have a functional function that can duplicate a record so that I can edit a specific field and not have to enter all the data for all the fields in a new record. However, now I have a table that is in a one-to-many relationship with another table and this function will only duplicate the...

Actually, that was probably the best part of your suggestion. I can think of other recordsets in functions that I did previously inwhich that would have simplified the process. I will use it in my project. Thanks again, PC

Thanks for your help. I got the code to work.Public Function wmConvert_Containers(intContainer As Integer, intInventoryID As Integer) Dim db As DAO.Database Dim rst1 As DAO.Recordset 'Insert data into table. Set db = CurrentDb() Set rst1 =...

I'm getting an error in my code on the first EDIT command and I'd like to request someone's help. The error is: Public Function wmConvert_Containers(intContainer As Integer, intInventoryID As Integer) Dim strContainer As String 'Convert option value to checkbox value 'Insert data into...

Its amazing what a little self determination can come up with.Public Function InsertLabels() Dim intCount As Integer Dim intRecCount1 As Integer, intRecCount2 As Integer Dim intChemicalID As Integer, intComponentID As Integer Dim strComponentName As String Dim i As Integer, j...

Thanks for your replies. I made the change and the counter is counting right; however, the loop is not looping the way I intended. Instead of looping through each of the components, its repeating the same component the number of times equal to the number of components. See code and...

I'm having trouble with my loop indexing. I can't seem to get the counter "j" to number the array correctly. The numbering should be sequential. Can someone help? Public Function InsertLabels() Dim intCount As Integer Dim intRecCount1 As Integer, intRecCount2 As Integer Dim...

Yes, in the US we call them MSDS or Material Safety Data Sheets which have chemical properties and chemical safety information. All the chemical properties necessary for reporting are contained there. See attachment. Also attached are the forms that I use for one of the agencies. Look at the...

Sorry if I'm confusing when I'm using the term "Hazardous Materials". This is actually a regulatory definition with reporting requirements. I see some responses to my posting with reference to atomic weights etc.; however, state regulatory agencies have interpretations that are more on the...

Thank you for your wise advice. I see that there are problems to be fixed before going much further on this. Our temporary worker who entered the data into my fledgling database didn't know to warn me of the data changing type (i.e. from text to numeric). The ultimate purpose of this is to...

I'm just getting familiar with A2K7 after about 5 years of using A2K; so I guess I didn't convert the file right. I think I did it this time; so see the attachment. As for the components table being denormalized, you're right. This is a small part of a large database that I seemed to have...

Craig, Sorry that I forgot to save my db in A2K format. I'm currently running Access 2007 (A2K7). I've converted the file and its attached to this message.Thanks very much for your design. I can get some ideas from it. The tables were taken from an existing large database; so I...

I have two tables: tblChemicalProperties and tblHazardousComponents. I've been trying to give rank values to the hazardous components using the percent weight field. Each chemical should have its components ranked by percent weight. I've attached a prototype database to show you my situation...

Query For Data Export Version: 2007 Seems like you're not the only one complaining about this website database. Why they designed it this way, I'll never know. Your help is appreciated. Thanks much, PC

I have two tables that are linked by a key field that I need to export for uploading onto a website database: Chemical Properties Chemical Components key field: ChemicalID I need help in developing a query or an output report to export the chemicals with their properties and the components from...

For those of you who can use this information, someone has helped me figure it out.Sequence: (SELECT Count(Index.InventoryID) AS TempID FROM tblChemicalInventory AS Index WHERE ((Index.InventoryID <= tblChemicalInventory.InventoryID) And (Index.BusinessID =...

I've have used the usual code format for creating a column of row numbers for my query, but it doesn't seem to work. Sequence: DCount("InventoryID","Chemical Location","InventoryID <=" & [InventoryID]) I got this error So I tried this: Sequence...

I used to have Snapshot Viewer Control on a form to use as a report viewer, but that's no longer available in Access 2007. So I was wondering if anyone has had used other viewers on a form such as: 1. Adobe Acrobat 8.0 Browser 2. Microsoft Office Document Imaging Viewer Control I've...

Copy & Paste A Record That's very convenient and works pretty good. Private Sub cmdDupeRecord_Click() On Error GoTo Err_cmdDupeRecord_Click DoCmd.RunCommand acCmdSelectRecord DoCmd.RunCommand acCmdCopy DoCmd.RunCommand acCmdRecordsGoToNew DoCmd.RunCommand acCmdSelectRecord...

I'm using an agency form in the background to make my report. Its a MS Word OLEUnbound on which I placed the data fields to fill in the agency's form. The form has a table where a list of chemicals needs to fit into. There are twelve rows to this list and when the list exceeds 12 I have the...