Search results

Yes, I know what you're saying. I have done a little testing, by adding next years dates and its spot on. I cannot forsee a problem with the method I have used. John

Hi spikepl. I altered my code to look like this: lastwkno = DatePart("WW", lastdate, , 2) It works now. In another part of this database there is a form for creating this tblcalender, looking at that it uses the same method to create the week numbers. I did look before writing this thread...

Hmmm - that idea never crossed my tiny little mind although I have just tried it and theres a difference between the last week number in my table and the week number access produces using the last date. My table shows - 31/04/2011 as week 13. my code: Dim week As String Dim lastweek As String...

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 =...

Hello Bob, Thanks for taking the time out to tell me that. I have been guilty of using reserved words before, also naming my modules the same as the function in it.. I will alter my code accordingly and use your less complicated way to build the file name up. Again, Thank you. John

Yes, its not the first time I have made a simple but stupid mistake. I appreciate your time though. John

Thanks for the quick response darbid. I am noob at VBA and I have never heard of debug before. I have checked google out and it appears that I use the line at the start of the line I wish to debug. I did this, and it returned 'false' for both startpath and endpath line. As I am writing this...

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 would like to thank you all for your help, With the help of someone at work (who saw me type it out) the problem has been solved with the following SQL code. Its tested and working.... SELECT DBA_OfflineAlarmsTable.Counter, Min(DBA_OfflineAlarmsTable.MsgNr) AS MESSAGE_NUMBER...

To answer your question about where the reason is held: It is stored in another table and it uses the counter number as the reference. At the end of the day all this data is collected together and exported in an excel file. Like I said in my previous post, I will try later in the week, I...

Thanks alot. I am back at work next week and I will try it out. I have made a bit of a mistake though not sure if it will alter anything... Status 1 = Error Occured Status 2 = Error Solved and status 3 = Error ack....... Does this make a difference?

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...