Search results

Good day, The company I'm working for are planning on moving to windows 7 and therefore upgrading our current MS Access software from 2000 to 2007. My question is, can I just simply import all my Access 2000 objects including code into the Access 2007 and continue using it as I am now or are...

Hi Darth, As your EmployeeNumber field is a numeric field leading zero's will always drop out unless you do something as per Pr2eugin post. Lord Vader [The master has spoken. Lol :cool:]

Hi Yeah I tried to open it and it has got nothing in the zip file, I also downloaded it to my PC and the same thing there are no files contained within the zip file. Regards

Hi, Not knowing what version of Access your are using, the following is the code I use in Access 2000: DoCmd.Echo False, "Running Open Questionnaire Program" DoCmd.Hourglass True 'Turn on the Hour...

Hi Plog, Thanks for your response and I will read up on the pointer you gave me. Regards John

Hi Plog, Thank you for doing that, it is much appreciated, what would help me is if you could explain how you came up with that expression, what was your thought process in constructing that expression. It's something I've always struggled with and any guidance/help on how you determined how...

Hi, I'm still none the wiser, I want to find the first left space with the string and the get the string to the right of that space. How does the mid function achieve that. Regards John

Hi folks, I'm struggle to find information on how to find the first space on the left of a text string, for examlple: I have this string : FUJIFILM XM-1 16-50mm BLACK and I want to find the space between FJUJIFILE and XM and then get all the text from XM onwards. I have this...

Good morning I'm somewhat struggle to create/find code that will count the number of text files in a directory with one level of folders please see below: Directory path is : B:\ First and only level of sub folders: there are 100 of these and they all end in ".fof" These .fof folders...

Hi Namliam, Yes I do reference Excel 2000 so I'll remember that. I'll be checking a few other references too, just to make sure. Thanks. John

Hi Namliam, Thanks for the response, I do use referenced libraries I'll just have to cross that bridge and see where it leads me. Thanks once again John

Good day folks, This is one for the experts I think, I've just been informed that our company is moving to windows 7 and also moving to software that is compatible with windows 7 which means that in a very short space of time I'm gonna lose MS Access 2000 and will be working with MS Acess...

Hi NamLiam, I assumed from the example that manama gave in his/her 4th post that the data was coming from a text file, with semicolon's as delimiters, however having read back through the posts I note that I didn't read the information about it possibly being a unix file and so bombed along...

Ok, I don't know what version of Access your are using but attached is a word document with image illustrations of the process I follow to import csv files. I'm not familiar with the later versions procedure for importing csv files but I am assuming it is something similar to the contects of...

Hi, Perhaps I've got this wrong but I thought your wanted the data seperated into as you put it columns [Fields] according to the semicolon seperator, that is what I understood from your example that you provided. So are you wanting all the data to be in one column[Field]?!! Are you trying...

Hi, Based on the example data you provided I have been able to import that data into Access using the SemiColon as the delimiter and the results appear to be fine to me, There are 11 fields as a result.

Hi, As you can see from the responses by more experienced Access Guru's your file does not appear to fit the criteria for a csv file. Are the ";" the data seperator if it is then you can use that as your delimiter.

Hi, Can you upload an example or sample of your CSV file, this would help tremendously.

In order for anyone to help you they need to have a clear understanding of what it is you are doing and the purpose of what you are doing in order that they can provide you with the best help. If your unwilling to provide that information or examples of what you have by way of screenshots or a...

Hi, Just thought I add my observation on this, if you have a front end that is linked to your backend via the tables in it, then you don't need to open the backend database progammatically because when you opened up the linked table the backend DB is automatically opened also. So for...