Search results

I am very new to this so please don't mind my ignorance. I have a database with 2 Tables, 3 Queries, and 3 Forms. I just went into design view for query 1 (which pulled info from Table 1) and added table 2 (Show table, Add). The problem is, once I open Form 1 which pulled data from query 1...

I just opened one of our databases and noticed that one of our text fields no longer had the scroll bar to see the entire data inside it. Simple fix right? I just deleted the field and added it back and poof, the scroll bar appeared. The problem is, I got back more than I wanted. Now, all of my...

This probably wont even require VBA, I'm just brand new to Access. How can I have people type or scroll in a search box, pick the word there looking for, and have it show them the definition? Much like a Google search integrated with dictionary.com. I assume you'd use a combo box or something...

I'm trying to figure out how to make a form that would allow me to enter data and then choose what table I would like the data to be entered into. This way, people do not need to open and close all three of our forms to enter there daily specific data.

Heres What I'm trying to do: Team 1 Team 2 Team 3...

What would the code be to have a .mp3 (embedded or a set path) to start playing when the database is opened? Just looking to add a little pizazz to the database. P.S. There is only one form which is set to automatically open.

Not sure this is the appropriate place to post this but here's my problem. The Combo box we use to search accounts via the Zip Code is limited to 66,000 names. (Approximately) Our contact list is 88,000, any zip code we use that's starts with 8 or 9 (states Like California) wont show up. How do...

I am using a query that is computing net daily calorie intake. I also have a sub query computing the average daily intake based off of that field. My problem is I cant make the Average Field work on my form since the form is sourced from the main query. I tried making a relationship between...

I've set up a database for a friend who owns a workout center. The only thing I have left is to set-up a formula in the query to find out the average calorie intake daily. (Find the Median) I'm thinking something like: Average_Cal_Intake: [End_Day_Calories]\X My problem is "X", how do I make...

We have a mailing list with 83,000 names in it. Our problem is we need to send it to our printers without Full zip codes "55555-5555". I ran a query to find the incorrect format entries. "*****-****" and came back with 43,256. Now I need to do an update query to change them to a five digit...