access database

Hello, I am running the code below (from Terry Kraft) from within excel and it forces the user to select the location of the files to import into access (opens up a box where the user navigates to the folder and clicks OK). I was wondering if anyone sees an easy way to adjust the code so I can...

I am trying to create a small database for a project I am working on but I am not so well versed in Access. I have attached the database to my google drive for review. I was wondering if someone could help out or at least point me in the right direction to success as I can not find the...

Hello. First of all: thank you for all the times this website has provided me with answers through threads posted and answered by people who have been here longer than me. I'm sure that if I wasn't so clueless this time, I would have found a solution on the forum already. So this is the...

hi, in my work place i got an access database which contains several queries. each time a user need to run a certain query he must open the database, select the proper query and insert a value(i.e. date) and press run to get the data. the main problem is that most users dont know how to open and...

I am working on a spreadsheet which is growing in terms of size everyweek, currently it is about 30 MB. So I want to use Access as a Database for this Excel Sheet. Here is the situation. 1 excel sheet with 3-4 tabs + 1 Master Tab. Master Tab has formulas (lots of them) which spits the values...

Hello, <?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" /><o:p> </o:p> I am very new to access, with moderate experience with VBA in excel. In Access I am trying to create an Attendance database for a group I help out with. Below is a schematic of what I am trying to...