Recent content by 1starr

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.