|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
|
Thread Tools | Display Modes |
|
#1
July 1st, 2009, 06:55 PM
posted to microsoft.public.access.forms
|
|||
|
|||
Open Numbered Folder
I have a form where I can open the folder based on project number, however,
when I try to open the folder # 4 for project # 4 it opens folder # 44 instead. Does anyone have a good fix for this? Thanks K Board -- Message posted via http://www.accessmonster.com 
|
|
#2
July 1st, 2009, 07:53 PM
posted to microsoft.public.access.forms
|
|||
|
|||
|
Open Numbered Folder
"How" depends on "what" ... and we don't know what data you're working with!
Regards Jeff Boyce Microsoft Office/Access MVP "babyatx13 via AccessMonster.com" u7025@uwe wrote in message news:986ef46029bff@uwe... I have a form where I can open the folder based on project number, however, when I try to open the folder # 4 for project # 4 it opens folder # 44 instead. Does anyone have a good fix for this? Thanks K Board -- Message posted via http://www.accessmonster.com
|
|
#3
July 1st, 2009, 08:42 PM
posted to microsoft.public.access.forms
|
|||
|
|||
|
Open Numbered Folder
Project no. is a number field. I am just trying to open a folder for project
no 4 that has other folders in it. The folder I am trying to open is named 4 the folder it is opening is named 44. Jeff Boyce wrote: "How" depends on "what" ... and we don't know what data you're working with! Regards Jeff Boyce Microsoft Office/Access MVP I have a form where I can open the folder based on project number, however, when I try to open the folder # 4 for project # 4 it opens folder # 44 instead. Does anyone have a good fix for this? Thanks K Board -- Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/For...forms/200907/1
|
|
#4
July 1st, 2009, 09:26 PM
posted to microsoft.public.access.forms
|
|||
|
|||
|
Open Numbered Folder
Are you sure you are working with Access, the relational database that is
part of Microsoft Office Professional as it has no 'folders'? "babyatx13 via AccessMonster.com" wrote: Project no. is a number field. I am just trying to open a folder for project no 4 that has other folders in it. The folder I am trying to open is named 4 the folder it is opening is named 44. Jeff Boyce wrote: "How" depends on "what" ... and we don't know what data you're working with! Regards Jeff Boyce Microsoft Office/Access MVP I have a form where I can open the folder based on project number, however, when I try to open the folder # 4 for project # 4 it opens folder # 44 instead. Does anyone have a good fix for this? Thanks K Board -- Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/For...forms/200907/1
|
|
#5
July 1st, 2009, 10:10 PM
posted to microsoft.public.access.forms
|
|||
|
|||
|
Open Numbered Folder
YES …… I created these folders using Access now I want to open them using
Access. This is obviously a number issue; it is finding the first occurrence of the number and opening it. I just want to know how to fix the problem. KARL DEWEY wrote: Are you sure you are working with Access, the relational database that is part of Microsoft Office Professional as it has no 'folders'? Project no. is a number field. I am just trying to open a folder for project no 4 that has other folders in it. The folder I am trying to open is named 4 [quoted text clipped - 13 lines] Thanks K Board -- Message posted via http://www.accessmonster.com
|
|
#6
July 1st, 2009, 11:02 PM
posted to microsoft.public.access.forms
|
|||
|
|||
|
Open Numbered Folder
Repeating the same problem doesn't help us understand what you're looking
at. "How" depends on "what"... For example, where are you storing [FolderNumber]? In that table (you're storing in a table, right?), what is the definition of that field's data type? When you say "I created these folders using Access", what do you mean? What process, function, code, macro, ... did you use to "create these folders"? I'm with Karl ... I'm not familiar with using Access to create folders. More info, please! Regards Jeff Boyce Microsoft Office/Access MVP "babyatx13 via AccessMonster.com" u7025@uwe wrote in message news:9870a9a594cf7@uwe... YES .. I created these folders using Access now I want to open them using Access. This is obviously a number issue; it is finding the first occurrence of the number and opening it. I just want to know how to fix the problem. KARL DEWEY wrote: Are you sure you are working with Access, the relational database that is part of Microsoft Office Professional as it has no 'folders'? Project no. is a number field. I am just trying to open a folder for project no 4 that has other folders in it. The folder I am trying to open is named 4 [quoted text clipped - 13 lines] Thanks K Board -- Message posted via http://www.accessmonster.com
|
|
#7
July 4th, 2009, 08:49 PM
posted to microsoft.public.access.forms
|
|||
|
|||
|
Open Numbered Folder
Jeff Boyce:
For example, where are you storing [FolderNumber]? In that table (you're storing in a table, right?), what is the definition of that field's data type? I told you it is a number field. When you say "I created these folders using Access", what do you mean? What process, function, code, macro, ... did you use to "create these folders"? I don't see why that matters. but I am using VBA code to create a folder with the same NUMBER as the Project number, which is a NUMBER field. when I get back to the office i will try looking the folder number up using a string value and see if that works. sorry to have bothered you with my problem. K Board -- Message posted via http://www.accessmonster.com
|
|
#8
July 6th, 2009, 11:47 PM
posted to microsoft.public.access.forms
|
|||
|
|||
|
Open Numbered Folder
You'll find folks here in the newsgroups very willing to help... but until
we understand why and how, any suggestions we can offer will be fairly generic. You're there, we're not. You need to give us enough info to help you. By the way, "number" fields in Access are for doing math. If you aren't adding/subtracting/multiplying/dividing your "Folder Number"s, they aren't "numbers", they're text. If you don't feel you're getting the kind of help you need, feel free to post back with another thread. Perhaps if you present your situation at bit differently, one of the folks who frequent this newsgroup will be able to help. Good luck! Regards Jeff Boyce Microsoft Office/Access MVP "babyatx13 via AccessMonster.com" u7025@uwe wrote in message news:9895ac4029853@uwe... Jeff Boyce: For example, where are you storing [FolderNumber]? In that table (you're storing in a table, right?), what is the definition of that field's data type? I told you it is a number field. When you say "I created these folders using Access", what do you mean? What process, function, code, macro, ... did you use to "create these folders"? I don't see why that matters. but I am using VBA code to create a folder with the same NUMBER as the Project number, which is a NUMBER field. when I get back to the office i will try looking the folder number up using a string value and see if that works. sorry to have bothered you with my problem. K Board -- Message posted via http://www.accessmonster.com
|
|
#9
July 6th, 2009, 11:59 PM
posted to microsoft.public.access.forms
|
|||
|
|||
|
Open Numbered Folder
On Mon, 6 Jul 2009 15:47:46 -0700, "Jeff Boyce" wrote:
but I am using VBA code to create a folder with the same NUMBER as the Project number, which is a NUMBER field. when I get back to the office i will try looking the folder number up using a string value and see if that works. The names of Folders (subdirectories to use another name) in Windows are text strings... the text string might consist of just digits, but the name of the folder is STILL a text string, not a number. As Jeff says, we need some clarification of your question. -- John W. Vinson [MVP]
|
|
#10
July 7th, 2009, 06:37 PM
posted to microsoft.public.access.forms
|
|||
|
|||
|
Open Numbered Folder
Jeff Boyce
By the way, "number" fields in Access are for doing math. If you aren't adding/subtracting/multiplying/dividing your "Folder Number"s, they aren't "numbers", they're text. Sigh.............I did not create this database....the Project numbers started out number fields for auto number reasons, they are referenced in other tables as numbers therefore I have not changed the project number to any other format, therefore the project number IS a NUMBER filed. -- Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/For...forms/200907/1
|
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
