Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by 1starr

  1. 1starr

    Top Ten

    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...
  2. 1starr

    Data type mismatch

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

    Data type mismatch

    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...
  4. 1starr

    Data type mismatch

    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...
  5. 1starr

    Data type mismatch

    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...
  6. 1starr

    Security Problem

    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...
  7. 1starr

    Error message 3464

    Thanks!!!!
  8. 1starr

    Error message 3464

    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.
  9. 1starr

    Setting query criteria from a public function

    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...
  10. 1starr

    Setting query criteria from a public function

    I get blank report.
  11. 1starr

    Setting query criteria from a public function

    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.
  12. 1starr

    Setting query criteria from a public function

    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...
  13. 1starr

    Automate archiving

    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.
  14. 1starr

    Finding Current User

    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...
  15. 1starr

    Store deleted files in a different table

    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.
See more

Part and Inventory Search

Back
Top