Search results

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...

Thanks for the quick response. No, I hadn't looked there yet, but I will. I'll be back...

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...

Thanks jdraw, Worked like a top!

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...

Never mind Paul, I figured it out. Set to double.

Thanks for the quick response Paul, The field size is set to Long Integer. What should I set the field size to?

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...

Thanks a million missinglinq, The focus was set at the bottom of the form. As far as the design of my campy little database, yes, there are a lot of improvements that can be made. This is my first database design, and as I develop this monster, I am seeing a lot of issues that need to be...

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...

Hey Dale, Heres a copy of my database structure. Take a look and see what you think...

Thanks for the quick response, I created several queries based on the relevant tables, but my goal is to assign the field that holds the grand total to a form along with fields from other tables to create another calculated control. I am having difficulty with creating a form that I can assign...

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...

Thanks for your input Pat, but I can't figure out why I need to redesign my tables for the question at hand. I have one table that is strictly for floor prep, which includes everything from the floors, steps, patching, floating, etc., and one table for installation areas which includes the...

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...

Hey everyone, Sorry it took so long to post, but the problem was solved the other day. I just used the linked table manager to refresh the path to the b_e and the f_e was then able to find the tables on the new drive. Thank you to all who had valuable input. I really appreciate it.

Beetle, you da man! Next time I'm up North, the first round is on me. Thanks a million!