Search results for query: *

I need to create a quert that gives me the top 10 most sold item in each store. In other words I have approximately 8 stores that and I want only to find out what items are most popular in each location and with this query I will create a report showing by location what was the 10 most sold...

Thank you, that was the problem I had FindDate as a String when it should had been variable type as Date.

Below is the code I use. Hopfully this will help: Option Compare Database Option Explicit Public strDom As String Public strDate As String Public Function FindDomain() FindDomain = strDom End Function Public Function FindDate() FindDate = strDate End Function Private Sub...

I have tried as you have explain and I still get the same error. Here is an example of my query: SELECT [CERT June].Category, [CERT June].Weight, [CERT June].Status, [CERT June].Domain, [CERT June].DateofSRR FROM [CERT June] RIGHT JOIN Status ON [CERT June].Status = Status.Status GROUP BY...

I wrote code where a list box pops up and the user gets to select one of many dates which appears as 10-Oct-03 for example. The problem is that once the user selects the date it is pass through the code as 10-10-03 and by the time it is pass to the query where I have set the criteria...

My users are now unable to access the database. This problem did not begin until a week ago. When ever some of users attemted to open up the database they receive this error "Could not use 'Admin'; file already in use." instead of getting the logon box. This also occurs even when they...

Thanks!!!!

This is the error message I keep getting when I run my query: 3464: Data type mismatch in criteria expression. If anyone knows what this means please let me know. Thank You.

Thanks, for your help but all of sudden it started working. I don't know what the bug was cause yesterday I first step thru it and it seem that the flow of data for strDom wasn't flowing correctly and them when I came back to it today, it worked with out a problem. There must had been some...

I get blank report.

Yes, the value of strDom is set when the user enters the form and completes his entries. What I need is for the query to give the values for that strDorm so a new report can be produce with out the user having to enter that strDom data again.

I having attempting to get my query to get criteria input from a Public Function in order to create the output for a report. In the Public Function I have it set up like this: Option Compare Database Option Explicit Dim strDom As String Public Function FindDomain() FindDomain = strDom End...

I was wondering has anyone come up with a way to automate archiving old records after they have reach a certain time period, like anything over 6 months old? If there is a way your assistant would be greatly appreciated.

I was wondering if there is a way to find out who is logged into the database. I have a problem with identifying the person or persons who are logged into the database when I need to make changes, because they are accessing the database on the network. Any help with this problem is greatly...

I am attempting to create a delete button and program the button to send the items being deleted to a table, which keeps tracks of the date, time, and possibly the person deleting the info. Any assistant you could provide would be greatly appreciated. Thanks.

I have a report that is send to me by email in snapshot format. I was trying to import this data into my access database for analysis, but have been unsuccessful. I have already contacted the indiviual who sent me this attachment and he saids that the way they have their use interface set up...

Thanks, It worked.

I have a number of mutiusers that access my database. I was attempting to split the database by using the tool wizard, but every attempt I have made returns an error. I truely don't know what this error message is referring to. The message reads as follows: "You tried to assign the Null...

Thanks for assistant. This was good advise. I will proceed to split my database up. I wanted to do it before but was told not to. Also I have called the network people to check out the network connects, I believe that is the main problem because all my users are on the same network. I have...

For the last 2 days when my user's have been putting Data into the database they have been getting an error message that reads "No Records Found". This occurs after they have inputed at least a couple of records. When I go into the database to view the tables all the tables have...