Search results

How about using the wizard to create a button that will copy an existing record.

Thanks for the suggestion and I did try it but not working out like it'd like it to.

Can anyone help with how to create an HTML frame-like function? Basically two rows, menu buttons remain on the first row, second row would have the menu items and information window. Function would be: 1. Click on a menu button at the top (frame 1) 2. Selection options populates menu items...

Can't get it to work when I import the files I open up the login form and it doesn't automatically pull up the network user name it just shows #Name? It works fine when I'm running the example by itself. Anyone have any suggestions?

Do you guys know how to get this to work in access data project? I have a subform combobox that runs a stored procedure query based on a control in the main form. I type =Forms![frm_claimsentry]![PrincipalCode] in the criteria section of the query but it automatically converts it to =...

kind of the same problem with sum I have a subreport which has all the dollar amounts I wanted to get the sum of. I created a bound object on the report so that I don't have to show the subreport. I did a =sum([Reports]![reportname]![ObjectID]) and it just comes out blank. I have it in the...

almost there Thanks for the reply. The instructions said to select Microsoft DAO 3.6 Object Library but when I chose the 3.5 it didn't give me that error. The issue now is that it didn't copy the records in the subform. I'm went throuh each line of code and compare to the Northwind and other...

Could someone help me figure out what's wrong with the follow code? The debug highlights the following as the problem: "Complie Error: User-defined type not defined" and then highlights the following: Dim dbs As Database Any suggestions would be greatly appreciated. Below is the code: Private...

It appears that I can only convert Forms that I created using the Form Wizard as a Data Access Page, if I try to save a form that I created from scratch in Design View and save to a DAP it always comes back with an error that it access can't open the page because it is an invalid HTML format...

When you say on the other computer the database is intact, it appears to me that you're working off two database instead of the one you uploaded.

Okay, here's what I came up with but if anyone has any other suggestions please let me know. I created a macro to requery the items subform and put that as an event On Click so when they click on the items subform it now updates with the correct items.

Okay, here's what I came up with but if anyone has any other suggestions please let me know. I created a macro to requery the items subform and put that as an event On Click so when they click on the items subform it now updates with the correct items.

hey pono1 can you offer any suggestions on this one? I created the queries you suggested and it worked fine but now I wanted to create another subform (multiselect box) that only displayed items based on the selection from another subform. Here's what I tried so far: #1. frm_promos (main form...

pono1 THANKS! Worked like a charm!!!

pono1, thanks i'll give it a try.

could someone help with this problem I'm having with a promotional planning form. Promoplanning (main form) and promoplanning detail (subform). Three linked fields PromoID, PrincipalCode, CustomerCode. The subform has an Item field that is a dropdown. Problem is that I'd like the dropdown to...

I'm tryin got create a print reports macro group according to the example in the access 2002 bible book and keep getting errors. It says to type [Select Customer].Visible in the Action Arguments pane but when I do that, it automatically puts [] on either side of the word Visible. Don't know if...

Could someone please help with a copy record issue i'm having. I have a Form with 1 subform. Main Form: Promotion information Subform: Promotion detail (items included in promotion) I put a duplicate record button on the main form because most of the times the same items are used in...

Thanks for the suggestions guys! I created a main form using a query that asked for the client code and fiscal year and used those two values to form relationships with all the subform data. Worked like a charm and was able to delete a TON of queries and forms. Since not everyone knows all the...

My database is now up to 37MB and I think i'm creating unnecessary queries (174 total and climbing) for what i'm trying to do. I've got 21 different manufacturers that I wanted to show their data relating to their claims and other spending. Got one main query/form to enter claims information...