Search results
-
V
If statement effecting all records in continuous form
Nice, texbox works just fine :) -
V
If statement effecting all records in continuous form
Thats what I wanted to do, but its not allowing it for a Box OR a Checkbox. This was my second solution :) -
V
Textbox on form won't display currency format
Using bound controls works fine when I messed around with this, I have no idea why unbound ones wont. Is there any reason you cant just use bound controls? -
V
If statement effecting all records in continuous form
I want to create a highlighted effect behind my check boxes, to do that I added a bunch of boxes behind them, then added a line of code to check if the checkbox was true and change the box color as needed. The issue is that it changes the entire colume of my continuous form when I only want it... -
V
Question 21 CFR Part 11 Integration!
My current project requires that my database complies with 21 CFR Part 11, it is an FDA regulation for GxP projects. I wanted to know if anyone has experience with this type of project, as this will be my first one. Any tips on how to develop a database with this in mind? -
V
Yes its another Many-to-Many question :)
I love it! I think thats a great solution! -
V
Yes its another Many-to-Many question :)
Will the users also be able to add in the new COI records with that? I thought it would cause issues to have the subform be able to create new COI records and also link them. Granted I have been known to over think things :) What I really am trying to do is not create two steps, this is very... -
V
Yes its another Many-to-Many question :)
I think it might help to add that my users will always be starting from the CQA side. They will never start from the COI end. This might make things more simple so we can focus on just one side of the join. -
V
Yes its another Many-to-Many question :)
Humm, an idea I was thinking of was to have the main form bound to my CQA table and then just have a area on the form with unbound controls that match the COI table. A user would be able to select all the options from the unbound fields then click a add button that will create the new COI... -
V
confirm upon delete record
Under the database tools tab you can always convert your macros to visual basic. Then just add the code you need to show a message box. -
V
Multiple Records in Multiple Subforms under Main Form
It kinda sounds like you dont have a relationship setup between the main form and subform. You should have a FK linking the main form with the subform. Sorry if I misunderstood you. -
V
Yes its another Many-to-Many question :)
Hey guys I have done Many-to-Many forms a few times with a previous database so I understand the basic concepts but I wanted to see how you might tackle this one. I have a standerd setup: tblCQA Field1 Field2 Field3 tblJoin fk_CQAID fk_COIID tblCOI Field1 Field2 Field3 I would like... -
V
Add "save" button?
To me Save is a button I add so my users feel better :) Also might need it on unbound forums. -
V
When date is entered auto populate another date field.
On the after update event just play with the DateAdd function. http://msdn.microsoft.com/en-us/library/ms186819.aspx Should be simple :) -
V
Close a Query with no tabs?
Good points, I might limit the access level they have. Thanks for your help! -
V
Close a Query with no tabs?
I have a form that lets my users run querys and email them etc. The issue is that when you open a query with no tabs in access 2007 you dont get any kind of close options. Any ideas? -
V
Cant find ID unless all Combo Boxes have value.
Last chance to be my hero! -
V
Cant find ID unless all Combo Boxes have value.
My combo boxes use the following query to lookup values: SELECT [TypeOfAuditID], [TypeOfAudit] FROM [tblTypeOfAudit] ORDER BY [TypeOfAudit] So the tracked value would only be the ID, also I checked the subform and its based on a table not a query... I guess my thought is why do the combo... -
V
Cant find ID unless all Combo Boxes have value.
You might be on to something! I will play around with this.