Search results

Hello All, I am hoping someone can help me with a problem in VBA, I am pretty sure its an easy solution but my knowledge is limited with VBA, I am a bit of a newbie. I have a calender table which contains every date for a year (April to April) and the corresponding week number. I am coding a...

Hello All, I am building my first database for a friends salon buisness. He has requested that the database log's everybody logging in and out and the times so he can monitor this for irregularities. I have this code to the Log In button on the main form. Set dbs = CurrentDb Set rst =...

Hi there, I am trying to automate copying a file from one place to another in Access. The file name changes daily (the date) so it needs to build the file name. What I have looks like it SHOULD work, even hovering above the code I can see that everything is exactly as it should be. I can...

Hello all, I am relatively new to Access but am getting really in to this VBA. I just have a quick question about 'DIM' in code. I programmed a button so 'on click' it performed its function and at the end it asks the user if they would like to open another database. I used to the...

Hello All, Let me start by saying that I am new to access and also new to forums and the problem I am about to write about is difficult to explain but I will try my best..... Here goes. OK I work with a database called the 'Online Archive' it works in Access '97. To help you understand what...