I need a vba procedure that outputs the the date of every monday of the year. The output would look like
01/03/2011
01/10/2011
01/17/2011
.
.
.
12/26/2011
Any help would be greatly appreciated.
mrzebo1
Last Activity: Jan 10 '19, 01:16 PM
Joined: Jul 24 '07
Location: NJ
-
mrzebo1 started a topic How to code a VBA procedure that outputs the date of every Monday of the year?in AccessHow to code a VBA procedure that outputs the date of every Monday of the year?
-
Give a value to an unbound text box on an access 2007 report at runtime
I have an access 2007 report that I an executing from a form, The report is based on a query that i change when it is execuded using me.recordsource =, There is a text box in the heading that i want to give a value to when the report is executed. The following line of vba code is what i tried but i get an error stateing "the control can't be referenced unless it has focus". when i try to set focus i get the error "ms office doesn't... -
User access for an Access 2007 database
I have created an access 2007 database that is split into a frontend/backend. The frontend is located in the MyDocuments folder of each user. The backend is on a folder on a shared network drive. All users have Change access to the folder where the backend resides. The problem is it seem that I am the only person who can add/update/delete records in the database. When someone other than myself tries to delete a record the project returns error code... -
It does work for another guy and I fooled around with his trust center setting so he wouldn't get the secuity warnings for a different project. That's why I'm leaning toward Trust Center being the problem. the only path info is for the linked tables and I can find the back end db on the failing pc's. The error they receive is 3044-invalid path. -
Unfortunatlly the drives are mapped to the same letter but I'll look out for that in the future.Leave a comment:
-
Not sure what you mean. The simple answer would be that the path to my backend database is incorrect but I used the database splitter utility and the path is correct. The error being throw back is the following
3044:S..... is not a valid path. Make sure that the path name is spelled correctly.
The app works for me but not for some of my users.Leave a comment:
-
Access 2007 Database Split - User access issues
I have created an Access 2007 database that will be used by about 200 users. The front end will reside on the users desktop and the back end will be on a network folder. I used the database splitter to split the database and put the backend on the network drive. I email the frontend to a few users to test and some of them had access issues. Users recieved error code 3044 stating that the path is not valid. I think it has something to do with Trust... -
Stored Procedures for DB2 z/OS Developed with SQL Language
Does anybody have an example of a db2 stored procedure using temp tables created in the stored procedure? Also what type of impact would the temp tables have on the DB2 evnironment?
No activity results to display
Leave a comment: