Wow.
That is much easier and exactly what I was looking for, thanks!
Is there a way to start off the browse in a specific directory?...
jaccess
Last Activity: Jan 16 '08, 04:29 PM
Joined: Apr 11 '07
Location:
-
So.... I think I was able to figure out a way to have a file browse button on a form select a file and put the file path into a text box by doing the following (for anyone else who may run into this problem.)
Thanks for all the assistance puppydogbuddy I really do appreciate your help.
1. Create a new Module in Access name it what ever you want and paste the following code from http://www.mvps.org/access/api/api0001.htm...Leave a comment:
-
So I made a new form (in the same db as the example) with the a browse button and text box both named the same as in the example form then copied the same onclick function to the new form and got this error.
Compile Error Method or data member not found (Error 461)
Me.txtXLFIle.Va lue = FindFile(Me.txtDir.Value, "Please Select an Excel File", "Excel Files", "*.xl?")
with this...Leave a comment:
-
Once again even with your new code if I click on the "Please Select A Directory" button first then hit cancel then press the "Please Select An Excel File" button the browse function works.
Pretty strange.
FYI
On the form there is 3 buttons and 3 text boxes one for browsing a directory one to select a database and one to select an excel file.
I will make a new form with...Leave a comment:
-
I changed out the existing code with your code and there was no error but not browse either.
Right when I changed out the code this line was highlighted
If Not IsNull(Me.txtXL FIle) ThenLeave a comment:
-
That would make sense, but it is actually Me.txtXLF(I - this is a capital i that looks exactly like a lower case L in this font )le
In the debug screen when I mouse over this line of code that is highlighted
Me.txtXLFIle.Va lue = FindFile(Me.txt Dir.Value, "Please Select an Excel File", "Excel Files", "*.xl?")
there is a little tooltip pop up that says " Me.txtXLFIle.Va lue = Null...Leave a comment:
-
So I think the second example you sent me will work nicely
File Open Dialog Boxes without ActiveX
http://www.fabalou.com/Access/Modul...open_di alog.asp
but I ran into a small problem.
If I click on the "Please Select an Excle File" browse button first I get this error:
Invalid use of Null (Error 94)
and the following is what comes up with the Debug:...Leave a comment:
-
Thanks!
I'll check them out and get back to you.Leave a comment:
-
file browse button on a form
Hello,
I have been working on a project in Access 2003, that requires an excel file to be selected (via browsing through folders, then selecting a file), the selected file name will then appear in a text box.
This will all take place on a form.
I had no idea browsing to a file would be so complicated. After many hours of searching I think I have found the information I need but unsure as to how to make... -
Well I may have fixed my problem.
So just to recap: I have a query that produces the results I need ( Date sorted in ascending order with 3 other fields). The query gets the date range from a form.
The report which is produced reorders my dates in no particular order if the date range spans over a month ( Oct 23 to Nov 5 for example.)
A solution I found was to look at Sorting and Grouping (under...Leave a comment:
-
Something I have noticed is that the report will list the dates correctly if the range is within the same month. For example if I enter my date like start date: 10/01/2007 end date: 10/20/2007 on my form the report appears correct. But If I enter start date: 10/01/2007 end date: 11/09/2007 the dates are mixed up.
I will do more testing with my dates to try and see any patterns.Leave a comment:
-
Dates are being reordered in report
Hello,
I am running MS ACCESS 2003 and have run into a seemingly simple problem. Hopefully all I will need is a quick fix.
I have a report based on a query that lists a date, items received, items processed, and items remaining. The query gets a date range from a form. I am trying to total the items received, items processed, and items remaining fields.
When the report is run without anything like =Sum([fieldname])... -
Never mind, I found something which will do what I need.
For anyone else interested:
Create a command button to open an Excel spreadsheet from an Access formLeave a comment:
-
Open specific folder with a button in access 2003
I was wondering if there is a simple way to open a specific folder from an access form button.
I have a form that a user can enter a date range and either view or print reports based on the date range. These reports are based on linked excel files.
What I am trying to do provide a simple way (press a button) for my users to be able to open their excel files from the form instead of having to open excel, locate the folder... -
Ok, I took a look at your example and tried to rework it with my info, with no luck. Here is what I came up with based on your model.
...Code:SELECT tblALLBCPIC.ORDPCK, tblALLBCPIC.DATE, DSUM(""1"", ""tblALLBCPIC"", ""ORDPCK <= "" & tblALLBCPIC.ORDPCK & "") as Running_Count FROM tblALLBCPIC where [DATE] >= #1/1/2007# GROUP BY tblALLBCPIC.ORDPCK, tblALLBCPIC.DATELeave a comment:
-
Thanks again so much for your help and patience. I will check it out on Monday and post my results.
Have a great weekend! ( I know its only Thursday but no work for me tomorrow)
J...Leave a comment:
-
Ok, it is definnatly giving me a different number now, probably to one I need.
Is there a way to display all of the records though, to create a running total not just a total?
Also in order to show the running total for the month to date (based on the same date range) would I need to modify theline of code?Code:format(a.DATE,"mm/dd/yyyy")
Leave a comment:
-
Mostly. My background is in web design, SQL seems a bit more difficult (and powerful) then what I am used to. It has been a steep learning curve for me.
So now I need to figure out how/where to add the date range criteria is what you are telling me? Sorry for not really "getting it", it is all so new and challenging for me....Leave a comment:
-
Yes it gives me one record with the total for all the records in the table....Leave a comment:
-
Thank you for taking the time to post a response, your assistance is very much appreciated.
I gave it a test run and it did not give me any results for the running total, and it still listed all records in the table instead of what was in the date range on the form. I believe you are on the right track though.
I have not seen "AS a HAVING a" used before could you explain what it does?
...Leave a comment:
No activity results to display
Leave a comment: