Recent content by Djblois

I did post the example link. and I did compare them side by side using msgbox, instead of debug.print

@Gasman Don't you see in the code above, I did the same thing with a msgbox and the connection string looks correct

I am working on some vba to connect to an excel file, so I can insert new records or edit records from access. I have modified similar code that I use to connect to an access table, just updated the connection string with what I found here: Excel connection strings - ConnectionStrings.com...

How did I over complicate it? I called an object and initialized some properties. Then later in a second click event I tried to use those properties and the object is no longer in memory. If it is too complicated, tell me how you would have done it differently. I am here to learn.

Because if you aren't getting answers in one forum it is good to ask in others but cross-posting is not a good practice. It is always suggested to just post the link so multiple people do not give the same answers.

Find my description in the link: vba - Keep object in memory while is form is open (access) - Stack Overflow

What do you mean corruptions? I am loading the front end on to their machines while the back end sits on the server. I have already indexed, and gone through 99% of this list http://www.fmsinc.com/tpapers/faster/. I know the issue is mostly the network and speed of the device because the...

I have an Access Database that I created for users to do special orders. Inside the office it is quite fast but when users go out of the office, on their laptops and using a remote desktop connection, the speed is super slow. I already gave them a copy of the front end on their machines to...

Thank you this has gotten me 95% of the way but it is always showing as admin for UserName. Even though I am logged on as DanielB it shows admin? how can I get the actually logged on name? or is this something that needs to be fixed in Active Directory?

I found this code that finds a list of users that have a database open. I now want to open up a form with a table of all the people that have it open. I figure the best way is log it to a table and then use that table as a recordsource on a form. Then when I close the form, it deletes all...

the UserNames is what it will filter by. It is salespeople, so the names within the UserNames field is who the Salesperson has access to see. So their name will be in there and others, if they have access to see other salespeople orders.

Primary Key: OtherReceivingID Autonumber Foreign Key: SalespersonID Number The Groups: UserName Short Text

I have a query attached to a form. In which depending on the user logged in, it will need to query based on a different number of criteria. As an example: If user A then view Group A, Group B, Group C If user B then view Group D, Group E If user C then view Group A, Group E, Group F, Group...

That would automatically add those fields then? But status may change, is that still the best method then?

There isn't a default value; they are based on the new parent record.