Recent content by Access_Headaches

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

Just checked the table and form, both are set at plain text. Switched it to rich, then switched it back, and still cannot clean up the garbage.

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

I have very little Form Room. There are seventy definitions for different types of facilities we advertise too, these need to be coded correctly when they data enter. I figure to save space, they simply type the kind of facility they think it is, and they can match up the true definition to be...

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

Yes, they all have the same fields in the structure, they just are not all used on every table.

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.

http://img832.imageshack.us/i/accesspic.png/ This may help explain better Will try your idea as well, thanks Steve

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

That was exponential helpful. Getting the right properties to show to enable me to turn off the header viability off was quite nice as well! Sub-Forms are quite functional once you get a small understanding of them too. Back to my original question, any other sites you know of with "Good" tuts...

P.S. My main complaint with lyda.com is they have no Visual Basic Help or VBA Code Builder tutorials at all. This is where limits disappear in what you can do. (As you Know)

Quite impressive Sir, Quite impressive indeed. I'm learning access for work, we have a very basic database and I'm supposed to learn more in-depth material. Right now, I'm just running reports and doing minor modifications. Lynda.com has only extremely basic material available, do you know where...

Your answer lies above...