Search results

Hey all, I have a problem with a query. I'm trying to generate a kind of report. The database is for a warehouse of sorts. What is supposed to happen is someone Pulls up a Form (Pull_Sheet_Helper). They copy / paste a list of IDs into an unbound field called "isnlist". From the list, it...

Update - Found the issue. All is well. Had something to do with the ID and relationship. I set up another ID field that auto-generated a number sot that I can still have a relationship to the main ID, but that ID will have a sub-id for each line of property. (Not sure if I explained that...

Actually, I can't. It's on a SIPR (Secret) network. I'm in the US Army.

Oh - the other problem is that the code requires me to press save if I edit the data - even if I press the Save Command button. This is the code for my "Save" Button. Private Sub Save_Click () Dim LResponse As Integer Dim LMsg As String LMsg = "Do you wish to save changes?" LResponse = MsgBox...

Hey all. I am looking for a way to save both the form and subform with the click of a single command button located on the main form. I'm aware that the fields auto update when you go from parent to child, but that's not what I want. For this form, it's important that the forms do not auto...

When in design view, I click on the box for property - it's control source is listed as the "Property" field on the appropriate table. Any other suggestions? What could be causing this?

Hi all. I have been tasked with building a database from scratch. I know little about Access, and almost nothing about vb. The database is for a warehouse of sorts. So far, Most everything is going just fine. I have a question about subforms. My main form has an ID assigned to a...

Unfortunately, I'm very new to Access. Would you mind posting a walkthrough to do so? I'm sorry if that's asking too much. Of course, I don't expect you to write the query for me, but could you explain where I would go to start this off? Is this going to involve a lot of VB coding? Will...

Hey all. Sorry if this is a newbie request, but this is the first time I have created a database for a warehouse from scratch. I have my data tables set up so that each "Customer" has an ID, and each ID has a list of relative data - including the location of their property in the warehouse...

I'm trying to use a form for a Warehouse. I have an ID number for each "Customer" on the main form, and a property list on a Subform. How do I link the two forms so that every time I bring up an ID number on the main form, It loads the property list for that ID on the subform? I apologize...