Search results

OK so i think i solved this myself based on what you have all said. I created a new field in each tblRB5 with a default value of the site it relates to. Created a union query to join them. In the query that runs the output form i added the union query and added a relationship to both...

Yes i could use a union query to join them all but i would need to add another field to the tblRB5x table to add the site that they originated from. The added complication is that there may be a duplicate WIPNumber from 2 different sites so it would need to reference the site first/ I think i...

So the data in the tblRB5X is a log of "open jobs" once closed in our system they disappear from this report and we need to update the data. I want my DB to do the same but not delete the data completely. So if the WIPNumber is on the RB5 its still live and i still want it to show in the job...

Sorry, not sure i understand what you are asking. the tblDaysheet holds all the data and i want to use the data in each tblRB5 to act as a filter, if it doesnt exist in one of the tblRB5 then filter it out. Thanks

ok so have tried this But still no joy. So to be clear, i want the form (frmEditUser) to only display the record that is clicked on the form (frmUserList). The txtUserName is the same on both forms. I have done this sucessfully with numbers bit cant seem to do it using text!

Ok so this is a complicated one so i will do my best to explain So i have a table called tblDaySheet This is all my master data that spans data from 6 different sites. This table has 2 fields that i want to reference, WIPNumber and Site i also have 6 other tables labelled tblRB51, tblRB52...

Hi All Need some help again! i have a form that displays all the users in my system called frmUserList (form created from the tblUsers) I also have an edit user form called frmEditUsers I have set the on click event on the fields in the frmUserList to open the frmEditUsers but cant seem to...

Thanks for that. Worked like a charm

Hi All I have a DB that has a user login page. There is a table holding all the usernames and passwords. My issue is that it is not case sensitive. For example, my user name is Mark.Dooler but i can log in as mark.dooler I want to restrict this so i have to use the capitals. the code for my...

The user logs on and there is VBA code that sets 2 TempVars. One for the site they work at, the other is their username. The idea was to use these to filter date relevant to them/their site The tempvars then stay active untill the application is closed and someone else logs on.

Awesome Like........ lol

Hi All Me again. So todays issue is around why i cant get the bloomin cobo box to work So, i have a table with a list of users for various sites (tblUsers) I have a tempvar set to a specific site. I have a query on the tblUsers that uses the tempvar to filter a list of users just for that...

Hi Thanks for the reply I dont think i need DAO as i am using a later version of access. Minty has solved it for me. :)

Thank you. Your help is greatly appreciated. And im sure i will be back.....loads lol.

I do apologise, you are completely right. Actually making the change you suggested (and not my incorrect one lol) has fixed the issue :) Thanks for that.

No it must be a different one as i still get the same error with these selected. If i select the activex one the error moves to the highlighted below

I have been googling this but cant find the right reference. This is what i have

Hi, thanks for the reply Please see screenshot below:

Hi All The below code is coming up with a compile error as screen shot below Access 2016 is being used. Any ideas? Code: Private Sub btnLogin_Click() Dim rs As Recordset Set rs = CurrentDb.OpenRecordset("tblUsers", dbOpenSnapshot, dbReadOnly) rs.FindFirst...

Hi It came up with an error on this line on the vba editor tdlocal.RefreshLink Im sure its something i have done so will review again when i have time next week.