I'm trying to create an interface to import two Excel files and compare them for common entries. I've got the import part figured out i'm just having some trouble with the compare part. Here's what I got so far for the compare:
' set the variable for the first field to compare data with...
I have a form with a beginning and end date range search that filters a query what code to I put in the beginning box so that it always defaults to the first day of the current month?
I have two forms, the first has a listbox that pulls data from a query, the second you enter data to send to a table. I want to be able to choose a record from the listbox and view it in the second form, so that the form is populated with the data form the record you selected. I have it...
I have a command button on a form that has the Event Procedure of when clicked it sets the value of a text box to say "3". But when I set up the Event Procedure and then click the button I get the following error:
"The expression On Click you entered as the event property setting produced the...
How do you create a backup database for Security Enabled database? I can create one from "Database Utilities," but when I open it and try to login it says I don't have permission to use it.
Is it possible to disable the "Database Window" for read-only users? The database is set up where when you login the first thing you see is a form and you navigate through the database through a series of forms, not with the "Database Window." There is a table that I don't want read-only users...
I have a form and if a certain selection is picked it opens another subform. The both the form and the subform have a "document number" text box how do i automatically take the number that is on the form and put it on the subform?
I have a group of users who are read-only and when they try to do certain things on the database, that because of security reason they aren't allowed, they get a "Run-time error." Is there a way to get rid of the error and instead have my own pop-up message that say something like "you do not...
Is it possible to give permission based on an individual record.
Eample: I have two users userA and userB and i only want userA to be able to edit userA records and userB to only be able to edit userB records all in the same table.
Or even better can i disable certain box's of a form...
I'm trying to send a power point in an email and I want the powerpoint presentation to open automatically in slide show view when the attachment is opened. How would I do this
thank you
I'm tring to add IIF(expression,return1,return2) function to the criteria box in my query. The return1 and return2 expressions returns the results i would expect when they are alone but when I try putting them together(expression below) in the IFF() nothing is returned(I don't get an error...
I'm trying to set up user account and passwords for a specific database file, but the user accounts and passwords are being applied to all my access files. How do I make my accounts and passwords local to on database?
Thank you
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.