Search results

I've got a few things in here I can't figure out. Attached is what I have so far. I'm still lost on how to jump directly to the record in the new form that I'm in on the current form. Maybe looking at my database will show you where I am. Also, I have table called history for repair history...

I am making a database of all the computers at my company. It's based on the Dell service tag and includes everything about the computer, cpu, ram , hd, repair history, assigned user, etc. I want to be able to switch back and forth between 2 forms. One form (frmAssetViewer) is a detailed view...

I just discovered something else.. I created a new form and added the query fields that were giving me the #NAME?. On the new form it worked. Next I tried copying the working fields from the new form to the form I'm working on.. It worked, but now when I open the form it give me the error...

What do you mean by creating querys on the fly? I've only delt with simple querys, and since I inherited this database, there may be. Any ideas on the #NAME? showing up in the form? I need to get that problem solved quick so I can put this form update into production. Thanks, - Marc

Nope... There are no graphics. - Marc

I'm working with a database I inherited. Most tables are on an SQL server. I need to add on to a form, so I had more fields added to the main table on the SQL server. The form is based on a query, so next I went to the query and added the fields that I had added to the table. If I run the...

Thanks for the suggestions Rob, but I do want it to work when selecting all. Jon, That worked! Took me a second to figure out what you were doing, but I got it to work. I'm going to have about 10 combo boxes that update the query, so that's going to be a long query. I've got 8 of them...

I tried that and it works when the form first comes up and the combo box is blank, but there is no way to select a blank in the combo box again once something else is chosen. The combo box is eventually going to be set to default to 'all'. Also, the 2nd line in the criteria disappears...

I've got a combo box in a form that uses a query to display a table in a sub form. One of the option in the combo box is all. I'm trying to write an if statement in the criteria for the query so that it either show what is a match for what is selected in the combo box, or it shows all if all...

Thanks.. I think I just got it working.. I didn't realize you couldn't have a query and a table with the same name.. Once I tried to save the query with that name and it told me I couldn't use that name because a table existed with that name it all clicked! Thanks guys.. - Marc

Your saying if I create a query with the same name as the table everything in the application will look at the query rather than the table?? Everything in the application points to a table called CustomerData. If I did what you say, wouldn't I still have to go thru the whole application and...

Wouldn't that still involve going thru the whole application and changing everything to look at the query rather than the table? The only thing I can think of is to make a query to create a local table from the SQL table, then base the application off the new table. But then I'd have to run...

I have an existing database that has self contained tables. I found a table on an SQL server in the company that has better info and can replace one of my existing tables. The problem is that a couple of the field names are different. This is a pretty big database (lot of forms and code...

Let me sum up what I'm doing.. We have an information form that someone is filling out for each of our products for each of our customers. She has been maintaining a seperate excel file for each of the forms. (about 6000 files) I'm creating this database with 1 table for all the products (65...

I swear that was the first thing I tried and it didn't work! But I tried again and looks like that does it. Thanks, - Marc

I've got a pretty simple query that's giving me trouble. Attached is a picture of it: Basically I have 2 columns that are Sums. The 3rd column is an expression that divides one sum by the other. It was working fine until I went back and added labels to the first 2 columns (Sales and Price...

Ok.. new approach.. Tabs aren't going to work. I'll never get under the max objects on a form limit. So, I decided to try using subforms. I made a 'parent form' with a subform on each tab. The only objects on the parent form are the tabs, subforms, and a reference number from the table to...

This was working great untill I started populating the other tabs with controls. I've got about 50 text boxed, and there will be 10-15 tabs. I tried pasting the text boxes to the 6th tab and it gives me an error "Microsoft Access can't create any more controls on this form or report. If you...

Wow.. Thanks.. Much better solution. I've never played with tabs. I didn't even notice them on the toolbar. With tabs I can change between pages and it always stays on the same record no matter which page I'm on. Don't have to worry about syncing them. Saves a lot of duplication of work...

I tried that and it put a filter on the 2nd form so I could only access that 1 item. I want to be able to go thru the records, decide I want to view them in a different form, select that form, then continue going thru records. You can do a lot more with code.. I just need to learn it better...