To try to isolate when the form becomes transparent, I interupted the code with a message box in different spots. The strange thing is that when I interupt it, no matter where, the form does not become transparent, even after you click OK...
I am really baffled.
Rick Ruscin
I just made an unbound form and put a Microsoft Progress Bar 6.0 on it from the tools menue. Then from another form, I put a button that runs code that loops through sets of records. Written in the same code, I have it launch the form with the progress bar and scroll it. If you just open the...
Using Access, I have made a form to submit info. There is a required field that is only added via code by using the "submit" button.If you close the form without pushing the "submit" button, it causes an error and does not record any records. This ensures that all info will...
Using Access 2000, can someone give me an example of a carriage return command for a message box? I have a book that says to use the @ symbol as a carriage return, but it only seems to work if the message box is launched via a macro instead of code. My goal is to have a message box with multiple...
Using Access, I put a progress bar on a form that launches when I run code. When the form launches, the form becomes transparent. You can still see the progress bar and the frame of the form, but the background is transparent. Why is this happening and what can I do to stop it?
Thanks, Rick Ruscin
I import a delimited file into access. I saved an import specification and named it "ProdSpec". My problem is that I would like to start in the 4th row.(The first 3 rows are text, the rest are numerical) It is my understanding that can't be done, so when I run the procedure, it creates...
I am trying to write code to delete a file if it exists. This is the code that I'm using, but I get an error that says "file not found". What am I doing wrong?
Thanks, Rick Ruscin
Private Sub Command1_Click()
Dim CreditFile As String
Set fs =...
I imported a file using the wizard. Just before "Finish", I clicked "Advanced" and saved the specification as "ProdSpec". Then I wrote the following code to call on it. The problem is that I do not want to import the first four lines of the file. Is there a way to...
I am trying to automate a process of importing a comma seperated delimited file into access. Also, I am trying to start on the forth row. I saw this posting for a similar question, but need a little more specific explanation {is "SpecName" the name I give to the saved procedure? table...
I know this section is for questions, but I've got to thank those of you who have helped me in the last few days. I had been struggling with some VBA stuff for over a month. A friend mentioned this site and had my answers within hours of my posting. In particular, thank you RickSpr, JohnLowell...
I download files from my PC based cash register into an access application that I have developed everyday. The files are delimeted and have an extension that access does not recognise (.001). So I rename the file with a .txt extension. However, the files change names slightly eveyday. A file...
When I execute this command, I get an error that says it can't find file. It hi-lites the "Name strFileName As "Credit.txt" line. What did I do wrong?
Private Sub Command1_Click()
Dim strFileName As String
strFileName = Dir$("C:\~Master Files\SSM\001 Crday_*.001")...
Is there a way to refer to a file that changes names each day. I have a PC based cash register that I import files from every day. One day the file is named "CRDAY_25.001" and the next day it is named "CRDAY_26.001". The name before the underscore is always the same and the...
Can I rename a "non-access" file in another directory using code from within access? I import a delimted file from my PC based cash register. It has a .001 extension, which access does not recognise as a delimited file. If I rename it with a .txt extension, the process works. I would...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.