Search results

More info Its all in one table. Should I split up the tables? How should I design my query and what type of query should I use? Mike

I am creating a report which is based on a table of customer survey results all based on a scale of 0 to 9. I need to create a report that allows for month vs month comparison. I am not sure how to organize the report/query properly. Can anybody help me get started?

I am creating a report which is based on a table of customer survey results all based on a scale of 0 to 9. I need to create a report that allows for month vs month comparison. I am not sure how to organize the report/query properly. Can anybody help me get started?

Could anybody help me create a search? I have a list of data entries that has a date attached, I need be able to narrow the search down by searching for all data entries dated for a week past, 2 weeks past, 3 weeks, up to a month. I.e. Its November 14, and I want to run a search for all entries...

Possibly, however I am not entirely sure of what you mean by joining the workgroup to the network. Could you elaborate? Thank you very much for replying...I definitely appreciate it. Mike

I have a database all setup with the proper Users, Groups, permissions etc which I created using the security wizard, however when I try to access my database using another computer on a network I get a 'You don't have permissions to use this database' error message. However a username/password...

What I would like to do is have a user click on a button and by doing so a file, preferably a text file (*.txt) file would be exported to the hard drive. However, I am unsure about the code I should use. Can anybody help me? Mike

On my computer there appears to be a major Visual basic problem, on all of my Access databases I get the following error message whenever I click on any button on my forms: "Error Accessing File. Network connection may have been lost." I am not on a network and the problem just appeared after...

I deleted all of the forms which contained the ActiveX calendar however when I go to the Visual Basic Project explorer they are still listed and i can't seem to delete them from the Project Explorer. I think this may be causing the problem, do you know how I can delete them? Mike

One thing I forgot to mention is that the error message asks you to press an OK button which then takes me to a VB code screen of a particular report called CONTACTSHEET, and in the code there is only this line: "Option Compare Database"

I wish I could, the big problem is that it has affected a lot of buttons that perform a wide variety of tasks, this problem just popped up a few hours ago when I tried to put in an ActiveX calendar.

This error message just started to pop up pretty much out of nowhere whenever I click on a button to go to another form. Some buttons are affected and others aren't. "Error Accessing File. Network connection may have been lost." I am not on a network, and my db is on my computer. Can anybody...

Does anybody know how to create a proper username/password pop up box that doesn't need to look into a table for the values. I want a username/pop up box to come up when a user hits a particular button. Cheers, Mike

Location Can you give the the URL for the MS download site?

Thank you very much, looks like I have a lot of options. I am going to start reading other time related threads. Cheers, Mike

Could somebody tell me if I could set up a 24 hour timer to my program, what I would like to do is to have a user click a checkbox. Once the checkbox is checked a 24 hour timer starts, at the end of the 24 hours I would like a Message box to pop up. Is this possible? Cheers, Mike

Hi, I was wondering if somebody could tell me if the following is possible, and if so how I could set it up. I would like to be able to click on a button and a small calendar would appear, after selecting a date on the small calendar I would like the date to appear in a text box. Cheers, Mike

Its actually quite simple; txtList.value = lstOptions.value I am fairly new to Access, I know there must be a way of properly setting up the code for what I want to do. Mike

Hi, I have a listbox with about 10-15 entries, a command button, and a text box. What I would like to do, is when the user selects an entry from the list box and presses the command button it would put the value/text of the listbox entry that is selected into the text box. I have gotten this...

Multiple fields in an email Thank you very much for that tip. I researched it and it would appear to work, I just need to know how to add multiple fields in an email. Right now I can only get 1 field to be displayed in an email using the SendObjects action. Can anybody help me?