Search results

Got it. DoCmd :)

I'm not using a macro, what is DOCMD?

Okay that worked wonderfully, now I need this query to run anytime a change is made on a certain form. I have added it to before update, but is there any way I can make the 2 confirmation windows not pop up when the query is run?

I have two tables, each has a "status" for a project. In the left table there is only one instance of each set, but in the right hand table, each set may be used more than once by different Projects. I need the Status field of the left table to be set to "Assigned" if ANY of the sets assigned...

Alright I did that but it changed absolutely nothing.

The status field has 4 possibilities on one side, and 2 on the other. In 2 instances it will be one status on the left, in 2 instances it will be another status on the left. Right now I setup this Update Query just to do 1 of the status' to get it working: 8 is the id for the status...

Ok I have looked into this more and I understand I will need to use an "Update" query. I have tried to set it up but cannot seem to get my criteria right.

To add, I know this is going to include some sort of if-statement, I just don't know the extent of it or how much it will be.

I have two tables, each has a "status" for a project. In the first table there is only one instance of each project name, in the second table there may be more than 1, will always have the same name but may have a different "Status" (field). I need the Status field of the first table to be set...

What would I set the other fields to? When I erase the "Group By" (default) they get set to "Expression" and the query doesn't work.

I said "Got it. Thanks" for a reason :)

Got it. Thanks.

alright I edited the code to say: Private Sub Text23_BeforeUpdate(Cancel As Integer) Me.Text23 = Date End Sub When I put () it just dissapears. I updated a field in that record but it didnt add the date.

Is there any way to make a date change to the current date/time whenever something on a report is edited? I have a "Last Updated" field but I want it to automatically update itself.

I have a query that feeds a report. This report shows a "Set" and the "Charge Numbers" associated with it. Each set could have a possibility of more than one set of IT numbers. This means there could be say 2 entries for set "D7" and IT numbers for both of them. As a result when I run the...

ok update, I fixed the logon issue on my PC by putting a password on the Admin account and deleted all of the user accounts. Now when I logon on MY PC it works fine. When I logon to the COWORKER pc all the accounts still exist and I cannot login to the Admin account in order to delete all of...

My issue isn't securing the database, it's actually getting that logon screen to go away. I have a seperate login auth system implemented. I beileve a coworker 1/2 setup the security and stopped due to it not working properly. Now when I create a user group on my PC, I cannot see it on hers...

My issue is that I have a seperate login/authentication system implemented but when a user sees the first Access login screen they try to put in that password there. I think my coworker did 1/2 of the security settings in access and realized it wouldnt work right and gave up.

I currently have a network shared database. I setup permissions but only one PC shows a login screen when it starts up. The other just logins to "Admin" account which I have taken permissions away from and therefore cannot make any DB changes. Any idea how to fhix this?

Is there any way to change the order that the tab button cycles through the different fields in a form? Right now mine jumps ALL over the place and in some case even misses a field.