Search results

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

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

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

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

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

I have a form with a table behind it, i would like to have a button so that when a user clicks on it a smaller form pops up and any information that is entered is saved in the record on the previous screen/form. Both forms would have the same record source. Is that possible and how can it be...

I have a form that asks people to enter in certain information. What I would like to have happen is when the user clicks on a button some of the information in that form is emailed to an email address. Is that possible? If anybody can help me, I would be extremely grateful. Cheers, Mike

I have two tables with the exact same configuration, I need to create a query that joins the two of them together. When I have attempted to do this so far I get an error saying that it could not complete the SQL statement because of ambiguous outer joins. Can anybody help me?

I have a report which is based on a table which doesn't have a primary key by design. One of the key fields in the table is one called Claims ID, there could be several records with the same Claims ID. I need a report that keeps all of the records with the same ID on one page however I am having...

For some odd reason all of the labels in my reports are invisible. Can anybody help me out? Cheers, Mike

I have a form which allows me to add information into a table, however I need to verify specific piece of information against information from another table. For example: I have a field named Claims ID, when I enter the Claims ID number I want to be able to press a button called Verify and I...

I have a continuous form whose data comes from a query, and I have a combo box with values that I entered myself in the Form header. What I want to do is when I select a value in the combo box, the corresponding detail information changes. For example my combo box is called claim status, it...

Hi, in my table I have my primary key which is a number and they range anywhere from 1 - 1000 for ex one record's primary key may be 12, and another record's primary key may be 1023. What I need to do is to convert all of the numbers for my primary key in my table to 6 digits, ie 12 becomes...

I have a difficult task to complete. What I need to do is on my form I have a field called Claims ID which is the primary key in the table that is associated with the form. The Claims ID looks like the following: 65-A-2002-01 What I need to do is have the textbox automatically display the next...