Search results

I swear I used to know how to do this, but I've tried a few things and can't figure it out. OK. I've got a table with a date function. When you enter a file, it automatically puts in the date of entry. What I want to do is total the number of entries by month. I'd like the finished query to...

I just wanted to come back and say that it worked. The Null values were screwing me up. Thanks again, FoFa and redneckgeek.

I'm sure it's the Val([Street_Number]) that's causing the error too. But shouldn't the output of any Val() function be numeric? Is there a way to get around it? Thanks. :)

Hi all I'm running a query on street names, and I want to sort first by the name of the street and then by the number, which is in a string format. Because of the string format, I'm trying to use the val() function to sort it. My query looks like this: SELECT Cases_interim.Case_Number...

That did the trick, mearle. Thanks, you're awesome. And pbaldy and everyone else, thank you all once again, too. You saved my butt! I'll get the hang of this, someday.

OK, so I changed the name of the module, and that took care of the undefined error. Thanks, pbaldy! And now I'm getting a new error when I'm trying to run the query. It's a Compile Error: Invalid Qualifier for one of my variables. Here's the VB code. Yes, I know it's kind of hosed. My VB...

Just popping in to say thanks. I'll be trying your suggestions tonight, and yes, I've already found one mistake based on what you've all said: I gave the module the same name as the function. :o Thanks again.

Hi all I'm new to using VBA modules in Access, and I've got a question about using them with queries. Basically, is it possible to use a VBA module to deal with data already entered. What I'm trying to do is take a street address with both numbers and letters (Example: 111A) and separate...

I have a table with a string field for a street. It might have data such as: Bleeker Street or Bleeker St. I want to create a query that will enable the user to search for a string by entering a parameter. Is there a way to construct a query using wildcards for a string so that if the user...

Thanks very much for the offer, fornation. Actually, I figured it out. It was XP. I reprogrammed the database on W98, and the report wizard worked fine. Then, just to make sure, I programmed it on W2K, and once again, no problems. I have to make this database on another machine, and then, I...

Thanks, fornation . . . To answer your question, it only comes up when I try to do a report that incorporates both tables. It will do fine if I try to do an all-ACT report based on the query or an all-DPT report based on the query. I only get problems if I try to do a report with values from...

You guys are gonna hate me . . . . . . but I was tinkering with this thing, and now it won't work again. DPT DepartmentID(PK) DepartmentName ACT ActivityID(PK) ActivityName ActivityDate AdditionalComments DepartmentID (FK to DPT.DepartmentID) I created the query like this: SELECT...

That did it!! Wow, I knew about inner joins, but just use the x.id=y.id out of old habit. This is the first time creating a report based on that didn't work for me. Fornation, you're awesome, thanks!

I have two tables for a test department/activity database (Which department hosts which activity). They are: DPT DPT_ID (PK) DPT_NAME ACT ACT_ID(PK) ACT_NAME DPT_ID(FK, referencing DPT.DPT_ID) This is simple, but it works fine for now (I'll be spicing it up later.). I created a form, did...

I have a department which has activities assigned. Most of the activities are predetermined, but I have a textbox marked "other" where activities not covered in the predefined list can be entered. Along with this, I have a yes/no box (IsOther), which the user can check to enable this textbox...

I've got a database with activities linked to a department. I want the users to choose activities for each department. Because I don't want users to mistype the activities, I have created a lookup wizard for the activities names. Is there a way to create a form that can add new activities to...

That did it, thanks! :)

I have a form/subform arrangement. The main form is called Department, and the subform Activity. My relationships are worked out. I should be able to post multiple activities to one department, but when I try to enter data, I get a message stating that I can't update. I checked for locks...

Yeesh, thanks Kevin (Sometimes I'm such a user!). I have another question, then. Is there an easy way to rig data entry so that the user can avoid entering the wrong information, or even avoid typing altogether? I'm thinking of a setup which would allow the user to enter "Car Wash" instead of...

Hi, all OK, so here's the situation. I'm doing a database for a company. We've got specific departments that can do specific activities. The activities are the same across all departments (i.e.--The activities "Email Notification", "Fund Drives", "Car Washes" apply to the Marketing...