Search results

Hello Everyone, Just wanted to know if there is a better way to write this procedure: Private Sub cmdCancel_Click() 'This line does not allow the user to close form if any field is populated If Not IsNull(Me.ClientFirst) Or Not IsNull(Me.ClientLast) Or Not IsNull(Me.ClientMainPhone) _...

Hello Everyone, I have a multiple items form that displays purchases for a certain area. The purchases include items from two tables, with two different numbers. I have just learned how to use the =DLookUp function, but I would like to eliminate multiple controls on each line by using one text...

Hello everyone, This is probably an easy question for most. I have created a multiple items form from a query that I created from tblPurchaseDetails. In this query, I have a field EquipmentDetailsNum that is in the purchase details table that derives from tblEquipment, but I would like to...

Hello everyone, When I update the data in frmPurchasesEquipment, I get the run-time error message: Microsoft Access cannot find the referenced form’frmPurchasesLivestockPlants’. I have requery code set to refresh the data in my combo boxes on 3 separate modal dialogue forms that the same...

Hello everyone, The answer to this would make my month! Let me see if I can explain this clearly. I have a user form that has two unbound text box controls (txtSupplierName and txtSupplierNum) that have default values set from another form that opens this form. On the form that has the two...

Hello everyone, If designing and formatting my simple little database isn't time consuming enough, I have spent the past couple of hours trying to figure out this little conundrum: I have recently started, just within the past few days, having an issue with opening two .accdb files at once...

Hello everyone, I am having a hard time with this project that I'm working on at the moment. I have created a modal dialogue form that has a macro set to open another form and close the current form at the same time. The form that is being opened has textbox controls that have the default...

OK everyone, I have a bit of a quandary here. I have 3 tables, tblClients, tblClientDetails, and tblSchedulingDetails. I have a field in tblClientDetails to contain the client number from tblClients, and I have two fields in tblSchedulingDetails to contain the client number and the client...

Hello everyone, Simple question for most, How do I equally space buttons on my forms using the property sheet in design view? I have been using the ruler, but it can be a pain sometimes. Thanks to all who know more than me...

Hello All, Just a quick simple question for most that participate in this forum. I just need a quick, simple expression that I can copy and paste into the input mask for a control that I have on a couple of forms that prevents someone (me) to continue tabbing to the next control if the...

Hello all, I want to track purchasing customers. I have created two tables, tblcustomer, and tblcustomerinvoice. I have created a yes/no field for purchased in tblcustomer, and placed that field in frmcustomerinvoice and set the properties to =1 so that it shows that the customer purchased...

Hello everyone, This will probably be an easy solution for most, but not me. How do I change the sub-data sheet in a table to reflect another table instead of the table I chose? Thanks to all who know more than me...

Hello everyone, I have created a user form that contains check boxes for various fields, and on this form, when the box is checked, I get a prompt that the field cannot be updated. I have several other forms that use these same yes/no fields, and I am not having the same problem on these...

Hi everyone, I am trying to create a db structure that will allow me to access my be from the cloud. I have run a compatibility check and fixed most of the issues, but the error that has me stumped is this: ACCWeb105016 Error text Relationships that are not associated with a valid lookup...

Hello everyone, I have created a sub form in a form that allows data entry for order details. I have a column that holds order amounts that automatically rounds up or down, and I don't want this. How do I fix this issue? I have examined the back end table properties for this particular field...

Hello all, This may be something very obvious for most of you, but I have created a form for invoicing, and when the form opens, it opens at the bottom of the form and the user has to scroll up to get to the top of the form. How do I fix this? Thanks to all who know more than me...

Hello all, I posted on this very dilemma a couple of weeks ago, got busy, and now I can't find my post. Sorry everyone, and please excuse the data redundancy. Also, I did get a response, and sorry to the person that responded. I know you have better things to do than give advice that is not...

Hello all, I have created a table for installer invoicing, and have a field for invoice amount. I have created a user input form that allows a user to fill in certain pay rates for different aspects of installation, and would like to know how to make the invoice amount a calculated control...

Hello all, This has been a struggle for me to try and figure out for awhile. I have a query that pulls data from the following fields in 2 different tables: Area1FloorPrep (tblFloorPrep) ex. remove ceramic tile Area1Size (tblInstallationAreas) ex. 20 s/f, or just 20 Area2FloorPrep...

Hello everyone, I am having a bit of a problem with sharing the back end of my database on my company network. I have split my database and assigned copies of the front end to 3 other nodes while keeping the back end on a public drive. This has worked fine and dandy up until I added a new node...