Search results

Wow! You're right. It's because when this is done with a new product, the productID (and the whole product) is not yet actually written as a record in the table, despite being on the form. Can I add a line to the VB of the command button to save the record right before opening the Detail...

ProdID = Null. I save the code, close the VB window, and then try to run the form in Access, so I think so.

Ok, I have this on the Product form: Private Sub cmdOpenDetailsForm_Click() DoCmd.OpenForm "frmProdDetails", , , , , acDialog, Me.ProdID End Sub And this on the Current event of the ProdDetails form: Private Sub Form_Current() If (Me.NewRecord) Then Me.ProdID = Me.OpenArgs End If End...

Thanks. I've had a number of different attempts at the code now looking at different examples. When a user adds or edits a product (with ProductID), and they click to open the form with product Details, I want the Product Details form to auto-fill the correct ProductID so that the details are...

Hello, I have done a lot of reading on OpenArgs and am trying to implement them but not having much luck. This is my cmd button to open a new form, sending the ProdID to the ProdDetails form. Private Sub cmdEnterProdDetails_Click() DoCmd.OpenForm "frmProdDetails", , , , , acDialog...

Bob, Not sure about the bound question. As for showing the records, I wanted to be able to select like this: DivisionID (filters next combo) StoreID (filters next combo) EmployeeID [Edit Employee] <-- cmd button to open frmEditEmployee

Ok, That would work. Then I guess set a tempVar and open that record somehow in a new window?

Thanks! So this would be a VB module? In place of CheckboxA, I can't just put the name of the checkbox, right? I need to somehow specify that it is selected. Same for the rest, needing to specify the values, etc. And how do I add that to the form? I created the module in VBA but it...

Hello, I didn't see a whole lot in google searches, assuming I'm searching the right term. What I need to do is offer a couple of combo boxes to narrow down results of records (I can do this) but then, based on the results that are left, allow the user to select a record to edit? How can I...

Hello, I have a complicated form, in wich fields may be selectable or not, or required or not, based on other forms. Looking for some guidance or tutorial as to how to set this up. Here is part of the form: [Checkbox A] [Checkbox B] [Field A] [Field B] [Field C] [Field D] Checkbox B...

David, I appreciate the addition to the conversation. I had seen that mentioned when I was doing searches online. So far it looks like the "Move to SharePoint" method will work well. Because users store a local copy of the linked lists on their PC, they can still enter data offline, and then...

I guess there is no way to send a report to word and maintain the charts?

With the tables as lists, there's no way to do input masks, for example, for phone numbers, is there? Also do you know anything about the performance using the SharePoint lists for tables in SharePoint Server 2010 and Access 2010? I read that for 2007 it got sluggish at 2,000 records and the...

Bob, Thank you SOOOO much. For some reason before when I had tested, I wasn't getting the "synchronize back to sharepoint" yellow bar, just the save to sharepoint one, which would overwrite the current information. Now I get the synchronize bar after carefully following all of your...

Bob, When I said "they say" I didn't mean you. Just various other articles/sites i've read. As far as the database on SharePoint, if the non-web queries, forms, etc. are downloaded to the User's PC but the tables (lists) are not, how will they perform offline entry? When I "move to...

Doing some reading, "they say" that using the database as SharePoint lists gets really slow once about 2,000 records exist. That would probably be an issue. A single report might reference 1,000 records from one of the tables. Or is the "round tripping" completely different? Maybe I...

I think I need to do more reading about this. Are you saying split the database? (to give the users a copy of the front end)? I did the "move to sharePoint" which converted the tables to lists. Then when I upload the database to SharePoint, and to open it I had to save a local copy. As...

Bob, Sorry for my confusion! I didn't see the block of red text to the side of the image, but that clears it up! Worked great! One more question. I have a laptop with Access 2007 and it gives you the choice of a location to upload the database onto the SharePoint site so that users can...

When I set the indexes, I have the three fields that make a unique entity. I also have the Primary Key (autonumber) because it apparently is required. However, when I set the three original fields to "unique" in the index menu, it looks for any duplicate values in the column... not unique...

Right now the three-field primary key is comprised of the three single primary keys, one from each of the three tables. Are you saying I will have to use the new auto-number in each of those three tables? I want to maintain the current relationships. Can't the Primary key in each of the...