Search results

Tried NZ in various places but to no avail, just can't get it working, know I am probably only missing something simple, but can't seem to get there.

I'm not very strong with queries, but normally manage to find a way round the problem, but I have hit a brick wall with this one and need some help. I am making a system to tack site audits, each client can have multiple sites, and each site can have multiple audits assigned, and the tables...

This is where I start struggling a bit, don't quite understand the object part Which bit needs to be as an object for this to work?

the exports are run from another part of the code, after each export has run this code is called, passing the filename (filename) and the sheet name within the excel file (qry) to this code. All the exports are working fine, they have been running for months with no problems at all, it's...

I have a system that opens each morning, runs some checks and exports 3 queries to excel files. This all works nicely. I have tried to add some code to open each of these files, immediately after they are exported to apply some formatting to them, save, close then move onto the next export...

I have this on my system. On the key down event of the text box, I check for the enter key been pressed (Chr13) I think off the top of my head, if this is found do code, else do nothing. Works a charm.

I suppose it does help if I post the code that I mention lol, been a long day digging a big hole in the garden! But you were spot on with what you guessed as my code and also with the solution. Many thanks, all working wonderfully now.

Hi Guys, Have a feeling there's a really simple solution to this, but I'm struggling to find it at the moment. Have the code below, inserting the entry in a text box into a table, the below is just a test, works absolutely perfectly, unless there is a ' in the text such as "it's" then it all...

Problem solved. Searched for ages before posting this and nothing, as soon as I post it I find the answer within a few minutes, typical.

I seem to recall a while back, a feature within the developer tab, that would allow the user to fill in a form and repeat certain sections to add more as required. Does anyone know if this still exists as I can't find it anywhere, and searching isn't proving much help. Thanks

You could add a line to end of the .bat file which creates a txt file when it's finished before quitting. Len in your VBA after starting the .bat running, the next line checks for the existence of the text file, if it's not there, wait for a period of time then retry, if it is there delete the...

I tried DLookup and the difference between that and DCount wasn't much. Also tried receordset, which was about 3 times longer! Index is in place on the ClosureCode column in the DB. Tried it with rsCode.Record = 0 and rsCode.EOF and neither made any difference, have updated the linked table...

Hi, I have the following function, which generates an 8 digit closure code which is issued to engineers when they close down a job. Before it issues the code, it checks to see if that code has already been issued previously or not. I have it generating a random code, so that sequential...

Why not just have one front end, and when the user opens it set it to look up which version they require and have two switchboard forms or similar, and direct them to the appropriate one? Keeps everything in one place and makes updating in the future easier?

For checking all field have been completed on a form, a usually give the required fields a tag of "required" then in the code, loop through each control and check the ones that are required are not empty, if they are stop until they are not.

Security = DLookup("[UserSecurity]", "Userslist_table", "[Userlogin]='" & Me.txtUser & "'") See above, that might work. If you are storing the user security level in your table as a text field, then what is the point of the UserSecurity_table table that you have mentioned? It would be better...

I think you need to review the process that you are following here, as from what I can see your not checking if the password is correct, only that a password has been entered. You have a second table which has your security levels in it, the field in e user table should reference this access...

Assuming the Usersecurity field in table userlist_table is a reference to the security level in UserSecurity_Table then chage UserSecurity in userlist_table to an integer value as it is a FK to the other table. Then you can change you code slightly, as unless you need Security for something...

Your setting Security as an integer then assigning it a text value. Change you field to a numeric field in the database and try that.

My first thought would be the way you are checking SecurityLevel, either change the table to a number or make what you are checking a string. Try that first.