It appears to be working now. But to follow-up, the value of Week is something like 201002 (year & weeknumber).
But thanks so much for your help. And the tips on troubleshooting !
CCHDGeek
Last Activity: Apr 28 '10, 10:48 PM
Joined: Oct 17 '07
Location:
-
I haven't tried creating the folder dynamically. I've only tried creating the Wk1 folder prior to running the code. But I still get the same problems. I think it's something concatening "\" with the rest of the string for the file location.Leave a comment:
-
Transferspreadsheet & Path as String
I'm using Access 2007.
I'd like to create a dynamic string variable to the use in the Transferspreads heet function in Access. The string will be the location/filename for the spreadsheet.
The string will look something like "\\Directory\Su b1\Sub2\Wk1\Exc el.xls"
I'd like to create the string with code. Example:
DirStr = "\\Directory\Su b1\Sub2\Wk" & WeekNumber & "\"... -
FishVal ~ this worked perfectly! Thank you so much for pointing me in the right direction.Leave a comment:
-
Disappearing forms -
I have a form that opens when an Access 2003 database starts up. In the VBA for the form, I have a complex function that is copying files from various folders and updating several tables. But the form either disappears as its processing or never completely loads - so it looks like nothing is happening to the end-user.
I've tried using
Me.Repaint
Me.Refresh
And neither of those is making the form visible... -
Access Form Scrollbars
I'm hoping this is an easy question but here goes. What would cause a form to load and not be positioned at the top of the form?
I have a main form with a subform. Inside the subform, I have pages/tabs setup. When the main form is loaded, the subform is scrolled down the page and you cannot see what is at the top of the subform. What would cause this? And how do I fix it? It also happens when you click some of the page tabs (the subform... -
Reaching 2gb limit in Access
I am automating a process using Access 2003 (SP2) by importing csv files as tables. The amount of data was causing the database to reach the 2gb limit. Now I am deleting the tables after I am finished using them but, the database is still reaching the 2 gb limit. If I compact and repair the database it's size is 445mb. Is there a way to "refresh" the database to realize that the 2 gbs of data are no longer there without compacting and... -
The backend is saved on a shared drive on the network. Each user has an individual front in that is saved on their personal computer.
I was forced by my employer to build a database for our team, and it's been a difficult road - figuring out everything. WIthout this board, I'd be totally lost....Leave a comment:
-
I am still having issues w/this problem. It seems now that while the database is in use on another computer, it does not work correctly on any others. On some computers, the subform is disappearing altogether. Is this a problem w/the way my backend is setup?
Thanks.Leave a comment:
-
It is split and runs across a network.Leave a comment:
-
Yes, I am using an Access Backend.Leave a comment:
-
Datasheet View Subforms - Not Allowing Data Entry
I have a subform that is searched according to a field value on the main form.
The subform has mutiple pages and each page has a subform based off a query. Today when I logged into the main form, none of the subforms that in are Datasheet view are allowing data entry. In fact, none of the rows are even visible. All I can see is the column title row for each datasheet. What does this mean? Are my queries not setup correctly? Is... -
The deletions could potentially happen at anytime and the same thing happens. My apologies regarding the code tags, I will remember that in the future.
I'm not sure if I understand your question regardin the connection, but I am using lines like:
...Code:With ppt With Presentation .Slides(CurrentSlide).Shapes(4).Table.Cell(TestNum, 1).Shape.TextFrame.TextRange.Text = rs![MER_DEPT_NBR] EndLeave a comment:
-
Phantom Records Even After Delete
I have a client-server DB, main tables in back-end, forms in front-end. The front-end is on each person's individual PC. I'm using the following code to declare a recordset and an instance of Powerpoint.
...Code:Set db = CurrentDb Set rs = db.OpenRecordset("SELECT * From WEEKLY_UPDATE_TABLE ORDER BY WEEKLY_UPDATE_TABLE.ENTRY_DATE DESC , WEEKLY_UPDATE_TABLE.ENTRY_TIME", dbOpenDynaset) rs.Requery Set ppt = New -
SQL/VBA - Finding query result/No records returned for query
How can I tell if a query result empty (ie there are no records with the specified criteria). I want to change a form's design based on the result of the query it is based how. Does anyone know how I'd go about doing that?
Thanks -
Thanks for your response!. That worked. And thanks for the welcome too. This is such a great community. I haven't asked many questions, but I've had so many answered just by searching the forums. I hope that I'll be able to answer some questions soon. :)Leave a comment:
-
Continuous Form - No Data Entry
Hello everyone:
I'm using a query as the datasource for a continuous form. On the form, there is always the last record where you can enter a new record. Is there a way to remove that from the form? I only want to show records that already contain data and to remove the option to enter new records.
Thanks for your response. -
If you don't mind doing that, that would be great!...Leave a comment:
-
Well, I found tutorials to help with this error, and what I did to fix the problem was log into the database on the individual computers, uncheck a select reference and then reinstall it, and it seems to work.Leave a comment:
-
When I used dbOpenTable, it seems to just continually print records repeatedly. And there is no change when I use dbOpenDynaset.
Any other suggestions?Leave a comment:
No activity results to display
Leave a comment: