Search results

I am using the notinlist event to ask the user if they would like to add new info into the underlaying table. If they do, it opens the form based on the underlaying table. My issue is i would really like to pass the contents of the combo box to the new form via openargs. I have read many...

After more thought, I came up with the attached relationships for my database. I think it will allow me more room to grow in the future. What do you pro's think? Is this a solid solution and a decent use of normalization?

Hello all, I have been tasked to create a database to track tooling information for my company. I have a solid idea on the process involved and would like some help getting my tables and relationships setup with normalization. I have noticed in the short time I have been learning access that...

I guess it is working, just not how I thought it should. It will only display the audit trail information when I am on the record that was changed. This is bothersome as I use the datasheet view for my subform. The audit trail information is not displayed in datasheet view. Currently I am...

That seems like exactly what I have. I have 3 subforms on my main form. The audit trail works great for the main form, however, the subform audit trail does not report anything when you change the subforms. I have placed the audit trail info into the query that I use as source to the subforms...

I haven't seen this work on any of my subforms yet. I have included the auditrail in the query field. I have made similiar sub forms using tables as the source and it works, however, I need to use queries so that I can do some expressional math to certain fields. If you have a brief example...

I am having similliar issues with creating the audit trail example in subforms. My biggest question is does this example work when a subform is created from a query? I can get the audit trail to work on a form that has a table for a source but not a query based form.

Ahh hah, after read more from a search here, I learned that you need to put the sum in the subform and then you can call the information back using the control name.

I am trying to create a small database to handle tool work orders for our shop. Currently the sum and totals are giving me grief. I am a neophyte with this so bear with me. I have two tables, the first keeps the infomation regarding the work order. The second holds information regarding the...

I have a form that is based from a user input querie. I want it to check to see if the value that was entered by the user already exists in the table, then hide certain fields on the form before it opens. Does anyone have a solid solution to this? I have tried to trap out the querie [Enter...

I would like to hide buttons and forms based on what access level that user has. i.e. If a user has "Admin" it would allow the form to be run, but if they had "Basic User" it would reject the request. tblUsers: strUserName strPassword strAccessLevel If User A logins and has "Admin" in...

I have a db with low level security (A table contains a username, password and access level). The database startsup with the login form and asks the user for the input. I would like to know if it is possible (if so where to start) to hide and/or restrict users based on the value of the access...

Got it working...Thanks again for the help. This forum has always been a great resource.

heh, we arrived at the same thing almost instantly. However I still get the file not found. I simplified the path to point to the local dir C:\ and still File not found error is given. The file is there sigh...

First of all, Thank you for the help, you have been great. Secondly hurm...Here is what I have...I need a decent vb way to append the .pdf extension onto the filename. It outputs what it should, it just can't find the file. Private Sub Command6_Click() On Error GoTo Err_Command6_Click Dim...

The filename however, is stored in the textbox on the form. It isn't static and will point to various files. I need to pass what is in the textbox of the current record to the code.....something like hmm: fname = "current record . lngpdffileID" Hurm, I need to take a longer look at that...

I would like to know if it is possible to open a pdf file from access in the following way. I have a form that contains and shows a 6 digit number. This number refers to a pdf file in a certain location. I would like to add a button on the form to "view" the pdf, instead of making the user...

Of course I over complicated it...heh heh toupper is an old C programming term meaning change everything to upper case. Thanks for the solid advice once again.

I have a simple query that uses IIf to display what I need. Is there anyway to use say a toupper cmd like you when you put > in the format tab? Here is the query statement: SELECT IIf(Left([tblProject]![Tool#],2)="LA",[tblProject]![Tool#],"") AS [Tool#] FROM tblProject WHERE...

I now understand how my relationships were pathological, however, I do not understand your new relationship fully. If I can attempt to clarify the logic maybe that would help. The form should show: ECR#1 was written by Kirt, it adds partnumber1 and deletes partnumber2 from modelA & modelB. (It...