Search results

Just had some trouble entering the new year, so in case anyone had the same problem I'll post my fix: For year, I used to have Year(Date()) which wouldn't work work because in January, I was looking for stats from December 2008, not December 2009. I put this in the criteria...

I'm also looking for an answer to this problem...

The WHERE statement worked great. Thanks for your quick response. I'll check that website out too, looks like a good resource.

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

Ah I think you got it. The main form shows data from Table1 and the subform shows data from Table2. The macro refers to [DateModified] which is a field in Table1. I just assumed it would be ok since the tables were linked. I'll try changing it when I get back to work and post an update. Also, I...

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

Excellent that's what I was looking for, thanks!

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

Hmm ya I tried copying it but no luck. When I change the number in the combobox nothing below changes. When I use a subform the combobox works perfectly. The only reason I would rather not use a subform though is for looks and ease of use. The subform looks a little more confusing and takes up...

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

So when I use the code Me![CboGoTo] = Me![Request number], the combobox shows the [ID] number of the record instead of showing the [Request number]

Request_number is a field that contains the number/letter (i.e. 33, 34, 34b, 35) that the user is going to search by. The numbers are unique, but it's not the primary key. I have an ID autonumbering column for the PK. I made the combobox using the wizard and picked the "Find a record on my form...

It's acting kind of strange now. I have about 800 records. When I go for instance to record 500 in the combobox, it displays the information for that record, but the combobox number show 419 instead. When I click "Save and Next" it shows 501, but shows 420 in the combobox... Here's what I put...

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

Perfect, ya the AfterUpdate() one worked great. I don't use autonumbering as sometimes the file numbers repeat, so I couldn't use the first one. Thanks!

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

Great thanks for the information. Being able to have new reports based on a template will be useful.

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