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

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

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

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

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

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