Search results

What you are trying to do is very basic and easy but needs to be setup to work in the way you intend. The Drop Down Box is called a Combo Box. Please explain what your end result is and the starting point you have eg End Result - create a new Customer record Starting Point - blank form, form...

Finally got back to this issue. The subform is used on two different Main Forms and the combo box control Row Source sql refers to a control on the main form. This means the sql should be different depending on which main form is open. To access the sub form you need to click a command button...

Some databases use a temporary value rather then a calculated balance. Stock take is an example. You "Freeze" the stock on hand value, then when the stock take count is known, any difference becomes a Transaction (Sale/Purchase). This means One field is used to hold the Stock on Hand value for...

When you concatenate sql in vba you need a space of at least one chr. This can be in the preceeding line or the following line. strStartSql1 has the space. strWhereSql1 does not have a space on either the beginning or the end of the line. strSortOrderSql1 does not have a space at the...

Try =IIf([Taxable?]=-1,(1.1*[After Discount]),[After Discount]) Refer my post earlier about removing ? from names. You need to clearly set your condition for Taxable? Then state what will happen if the condition is True and what will happen if the condition is False. Your earlier example...

You need a space in the start of your string. strWhereSql1 = " WHERE qry_city_state_zipcode_01.uszipcod_city LIKE '*" & Me.cbocity & "*'" Other lines will also require this space.

Yes/No is 0 or -1 see this thread http://www.access-programmers.co.uk/forums/showthread.php?t=95107

No, my post is wrong with brackets. iif(Condition, Value if True, Value if False) Where is your Condition ?

Thanks RainLover. Got side tracked with despatching a rooster that was making too much noise.:eek: Back to access..

I just responded to what you posted which does not have the closing ")" Best to use the Hash Symbols when posting code eg=IIf([Taxable?],1.1,1)*[After Discount]) iif() is a function and must have equal brackets - which you have. Where the error is is dependant on your database. Why have you...

You need a closing )

The control source is not working. The expression may have a typo or other error that causes it not to return a value for the control.

MS Access 2010 accdb. We have a main form, frmLoanIssueData, and a number of sub forms. One subform, FrmRefinanceSubForm, has a combo box control with Row Source as this sql SELECT TBLAPPLOAN.APLPK, TBLAPPLOAN.APLACCDET, TBLLOAN.LDPK, tblLoanIssueStatus.IssueDate...

My first computer was a Commodor 64:D Went to night school to study Basic. We had a cassette tape drive to start with and then splashed out for a hdd. Became a User only for many years and then got re hooked with MS Databases in the 1980's. Joined this forum when our paid support people...

Study the copy database. I have added a Module with the Public Function to get the next Job Number. It would be very easy to build some samrt things into the function to have Job Numbers read Jobnnnn or some other idea. I also added a Command Button that will appear when the check box is...

You are using lookup on table fields. This is not recomended. Others mmay explain why or do a search. Better method is to use the form for lookup actions. Once you become familiar with using Forms for same you have better control on your data.

Table Client List has field name Date. Also Sort and Status. While these two names are not on my list of reserved words, I wouldn't use them, just in case. ClientSort, ClientStatus would be my choice.

Research Reserved Words. You have a field named Date - This is a reserved word and can not be used. JobDate, QuoteDate will work. Spaces in names serve no good purpose. QUOTE NUMBER - QuoteNumber. JOB NUMBER - JobNumber CLIENT - ClientID PRICE - SalePrice Check Hungarian naming convention...

tblClientList tblFeeder tblFeederJob tblRegister qryFeeder frmFind - what ? frmFindQuote ?? frmRegister

You should find better table, form and query names. Check out this subject as you wll save a lot of hardship by getting it right early in your database.