Search results

Hello, Actually, I think it is something with the way it handles the dialog in windows 7. I did get it to work but had to use a different method. I am including it below incase it will help anyone else in the future: Dim fd As FileDialog, strFilesSelected As String Set fd =...

Hello, Sorry for taking so long to get back to you. That is a great idea I will have to look into that in the future... Thanks again.

Hello, I have the following code that lets the user read in a text file and backs up the table and then addes the data to the main table and then removes the imported temp table, works great on my xp computer using access 2003, tried it on my laptop running win7 and access 2003 and it comes up...

Hi all, I am wondering which would be quicker. I have a combo box where a value would be selected. Then I would either have it requery a query to fill in the subform or to create a value and filter the subform and display it. Which would be faster as the record size grows?? I have created...

Hi all, Thanks again for all the help. I was able to get it to work. I added a column to the query using the monthname on the expression and that worked. I am wondering if there was any way to get the other to work using the [forms]! options. Just to have something new to learn. Thanks...

Hello, That helped a lot. I am now stuck with one little problem. I have the user able to select the month, but all my queries and tables store it as a number. So, I have setup the combo box to select from a record with 2 columns. The first has the month in words and the second has the...

Hi all, I have gotten a lot further on this thanks to a lot of suggestions and help from the people on this board. You can ignore my guidance question now as I have made a decision. I have the following code which will take 2 values from list boxes and open up a report. I now want to be able...

Hello, The ultimate goal is to have something that can be emailed to users, who may or may not have access. That is why I am looking at exporting a report using a selected record to word or something that can be emailed. I hope this makes it clear at what I am trying to do...

Hello, I am trying to export a report based on the values of the month and username for the person. I have a query with all the fields I want. I have created a report with the fields I want and look I want. I am not trying to figure out what is the best way to do an export and to what? The...

Hello, I have been able to create something very similar, are there other ways to write it? What I want to be able to do now is to export either a report using the current record or export it to excel using vba. Here is the code I was able to get to work: Private Sub Combo52_AfterUpdate()...

Hello, boblarson, thank you for the idea. I have that part of the code working perfectly. I am just trying to learn more on vba and fill in the subform using the select and where values. I know I should use better variable names, just because i had to create a chart to keep track of them...

Hello, No, it does not work. It does not seem to be going to the Report Sales Sellers at all so I do not know what I am doing wrong. This seems simple for those who know what they are doing. I am just trying to get a subform filled from a query names Report Sales Sellers where the month is...

Hello, The fields names are in the query that I am trying to use to limit it by. Before I was using the following: If Not IsNull(Me.Combo7) And Not IsNull(Me.Combo3) Then 'assumes bound column in combo is the month number strSales = "expr1 ='" & Me.Combo7 & "' AND MonthName(Expr3)...

Hello, Here is what I have written quickly to try and fill in a subform using the found value from the report sales sellers query. Dim LSQL As String LSQL = "select * from [Report Sales Sellers] where expr1 ='" & Me.Combo7 & "' AND MonthName(Expr3) ='" & Me.Combo3 & "'"""...

Hello, Sorry, I can't send up the code as I have not written anything yet, as I am trying to understand what it is doing and then to get it straight enough in my mind to apply it to my code. The month is stored as a number for the month, and the table lets them select january, febuary so on...

Hello, So in my case it would be something like the following: Select report sales query.expr3, report sales query.expr1 From [report sales query] Where (((report sales query.expr3)=Me.Combo3) AND ((report sales query.expr1)=Me.Combo1))) Does this look like it would work to be called from a...

From what I have been reading everyone said it is best to create a query with what you want in it to be exported. I have done that. I now want to filter out the month and userid from the report seller sales query from my view sellers sales form and export all the totals which is one record in...

I need it dumber, because I have no idea what supplierid is or any of the fields you are using there, or what transaction is, that is what is confusing me the most. That is why I included the names of the items to get a better idea on this. I also want to filter it on both fields is this possible?

Hi, I am trying to do a sql select from a query using 2 values from a "view sellers sales" form combo box. I am getting month and user from the combo boxes and I want to select the record from my "report sales query" using those 2 values. I have been trying this for a while but I am so...

Hello, I need some ideas and assistance. I am looking to setup a way to output my sales results. As you can tell I am a newbie on this and trying to help someone out. I have created the forms and they let me search for information and place it on a subform, that works great. It is now...