Search results

Hi I have number of queries and I want them too all return data based from the current month. At the moment in the query I have [Date] Where Criteria Between #01/10/2008# And #31/10/2008# Obviously I don't want to have to change it every month. Is there a way to make it select the current...

I have a form and displayed in it is a subform. I created a macro to put a datestamp on any record that is changed. It works fine for records edited using the main form. When I try to run the same macro in the subform I get error 2950; ActionName: SetValue, Arguments: [Date Modified], Date()...

Hi I have two things I want to run in my BeforeUpdate of a form. First, I want to have a TimeStamp macro to run. Second, I want an Event Procedure that asks the user whether or not they want to save. I can't seem to have both. I select one in the property sheet under Before Update the other one...

Hi, I'm trying to create a query to count the number of records based on information stored in different tables. For instance, one table tracks general complaints, another support complaints and a third product complaints. I want a query that would count the number of each. When I try to do...

Hi I just started working with multiple tables and relationships (woo big step), but I'm having trouble with recalling records now. I have a form for editing records. There's a combobox on the form that lets the user picks the record they want to edit and it brings up all its related...

Hi, I have a combobox which I made using the third option of the combobox wizard. The user can select an ID number and it brings up the record information below. I also have a save & next button, so when the user edits information they can click it and have the next record appear. This works...

I've been running into some issues with queries and inputing data by forms, but before tackling those problems, I thought I should make sure I have the best structure for what I'm working with. I've been playing with a bunch of different approaches and I've reached the point where it's gotten a...

Hi, I have a form where the user enters a file number which is in the format "YY-####", YY being the year and #### being a unique number assigned to the file. For example, "08-3457" would be a file number. In my table I have a field [File Number] that stores the whole file number, and also a...

Hi I have a database with about 20 different queries and each one (at the moment) has it's own report. Each report has a background picture, unique margins, header text/logo and footer information. Making a change now requires me to go through each report and do it 20 times. It's also a bit of a...

I have a field with about 400 records in it containing dates. I made a query to show the number of days that have elapsed between the date in the record and the current date. e.g. If the record is April 11, the query will say 116 days have past. Then I modified it so it would show the number of...