Search results

I'm not 100% sure what you need help with, but I'll take a shot. Your query is working correctly . . . you just need to know how to make it so users can retrieve data using it??? The best way to return data to a user is using a report. Basically, the query returns the data in "raw" form. The...

If you search for "confirm delete" in this forum, you'll find a number of examples like THIS ONE.

Highlite the combo box. Find the Default Value field in the property sheet.

Re: Forum Design View Access 2007 Glad you got it figured out. I now understand that you wanted to add a button for a new menu item. I was thinking you wanted to add a command button for something!

Try this in the default value of the combo box. It should force it to open empty. [cboSelect].[ItemData](0)

Won't that just hide the bad rows from the query? The form will keep throwing the bad rows into the table(s). I agree with rodme re macros. I don't use them. Try coding your command button using the vba DoCmd.OpenForm and see what happens.

Re: Forum Design View Access 2007 I've never added controls to a switchboard form, and it's been a while since I've used them. I think, though, that the area on the left where the text boxes are located is like a frame on a web page. Whatever is there will be the same for all menus. If...

Is it actually adding a blank record or is it just presenting you the form with the fields blank instead of with the fields populated populated with a row from the source? If that's the case, look at the property sheet and set "Data Entry" to "No". This will cause your form to open populated...

You're going to have a one-to-many relationship in your tables, with the table that tracks the payments on the "many" side. You should include a field to track the date of payment, such as Payment_Date, that will uniquely identify each payment. Basically, this table track all payments...

Re: Forum Design View Access 2007 You pics reflect three switchboard forms. It's not clear what subform you are speaking about, or it's possible what you are talking about is not really a subform. In any event, you should be able to see the subform among all of the forms listed and be able to...

Do you have a number of subforms that only one or none needs to be visible at one time? If that's the case, you can add a number of subforms to your main form and overlap them. Set them all to invisible. On your main form, code command buttons, one for each subform, to make the appropriate...

I'm not sure why you're getting that garbage at the top, but my first thought is that you're not starting with a pure text file. I'd look at the file with a hex editor to see if there is more there up front than notepad is displaying. As an alternative, you can try importing that file into...

I would add an autonumber field to your table and use that as the PK. Import the data from the spreadsheet and Access will automatically populate the PK.

I may have given you some bad advice here. Try binding the main form to the table (Bids and Proposal Register?). Also, you may want to consider NOT using spaces in object names in the future. They're just one more thing to cause issues down the road.

Did you manually enter that code based upon the example in the other database? I'm not 100% sure, but I think that's the code that Access will generate if you use the wizard. At any rate, I've seen it before. Try generating the combo box using the wizard and see what AfterUpdate code it...

The main form should be unbound. Create the combo by going through the wizard and insure that the PK is one of the columns selected. I don't think you need the where clause in your query. The link between what is selected in the combo box and what is displayed in the subform is done by...

I don't think I'd try to create a new record simply by updating a field in a record returned by a search. Even if you could do it, it seems like a dangerous way to proceed. One possibility would be for the form that contains the search result to have it's fields locked so that edits could not...

If by "relation arrows" you are referring to the arrows that point between tables in the Access relationship view, I think you may be misunderstanding their purpose. For a number of reasons generally set forth under rules termed Normalization, databases are organized into tables that are for...

Did you try trapping this with the form's Before Update property as JBB suggested? ICBW, but I don't think that simply populating a field on the form is going to trip this just because all the fields have not yet been populated.

I'm thinking that you have to force the user to close the form using a command button by removing the default "x". The code in the command button should test to insure OverUnder = 0. If it does, save the record and close the form. If it doesn't, open an advisory msgbox followed by setting the...