Go Back   Access World Forums > Search Forums

 
Showing results 1 to 25 of 500
Search took 0.35 seconds.
Search: Posts Made By: bob fitz
Forum: Queries 04-24-2018, 10:39 AM
Replies: 9
Views: 151
Posted By bob fitz
Re: Len function not working

While you were posting I was testing. Can confirm that
Len([license]) = 13
should indeed work. BTY you have made a slight spelling mistake in the name of the field.
Forum: Queries 04-20-2018, 12:22 AM
Replies: 17
Views: 250
Posted By bob fitz
Re: Dlookup query with multiple criterias

The DLookup is using the wrong domain.
I think it should be:Expr1: DLookUp("[CLOSING_VOLUME]","[INV_DELIV_QRY]","TANK_ID=" & [TANK_ID] & " AND [DATES] = #" & [DATES]-1 & "#")
Forum: Queries 04-20-2018, 12:02 AM
Replies: 17
Views: 250
Posted By bob fitz
Re: Dlookup query with multiple criterias

Expr1: DLookUp("[CLOSING_VOLUME]","[DAILY_TASK_WETSTOCK]","TANK_ID=" & [TANK_ID] & " AND [DATES] = #" & [DATES]-1 & "#")
Forum: Queries 04-19-2018, 11:59 PM
Replies: 17
Views: 250
Posted By bob fitz
Re: Dlookup query with multiple criterias

Can you post a copy of the db
Forum: Queries 04-19-2018, 11:52 PM
Replies: 17
Views: 250
Posted By bob fitz
Re: Dlookup query with multiple criterias

Sorry. Try:Expr1: DLookUp("[CLOSING_VOLUME]","[DAILY_TASK_WETSTOCK]","TANK_ID=" & [TANK_ID] & " AND ([DATES] = #" & [DATES]-1 & "#")
Forum: Queries 04-19-2018, 11:46 PM
Replies: 17
Views: 250
Posted By bob fitz
Re: Dlookup query with multiple criterias

Can you copy and paste the expression that you have tried
Forum: Queries 04-19-2018, 11:37 PM
Replies: 17
Views: 250
Posted By bob fitz
Re: Dlookup query with multiple criterias

Perhaps:
Expr1: DLookUp("[CLOSING_VOLUME]","[DAILY_TASK_WETSTOCK]","TANK_ID=" & [TANK_ID] & " AND ([DATES] = "# & [DATES]-1 & "#")
Forum: Forms 04-17-2018, 08:33 AM
Replies: 1
Views: 111
Posted By bob fitz
Re: Combo box issue

Have you set the Control Source property of the combo box to the correct field
Forum: Modules & VBA 04-15-2018, 10:36 AM
Replies: 6
Views: 171
Posted By bob fitz
Re: Exit inputbox after valid input

Possibly with code in the NotInList event of the combo box, or perhaps by using a "Case" statement instead of the "If" that I used.
Forum: Modules & VBA 04-15-2018, 07:57 AM
Replies: 6
Views: 171
Posted By bob fitz
Re: Exit inputbox after valid input

If selection of a particular value in the combo list requires a calculation to be done, then you could make the combo unbound and do the required calculation and set the focus to another control by...
Forum: Modules & VBA 04-15-2018, 04:37 AM
Replies: 6
Views: 171
Posted By bob fitz
Re: Exit inputbox after valid input

Create a Value List for the combo box. Put your numeric value in the first column and the text value in the second column. Set the column width of the first column to zero which will hide it when...
Forum: Modules & VBA 04-14-2018, 09:32 PM
Replies: 6
Views: 171
Posted By bob fitz
Re: Exit inputbox after valid input

If you want to restrict user input "b" or "v", why not use a combo box.
Forum: Forms 04-11-2018, 10:29 PM
Replies: 13
Views: 364
Posted By bob fitz
Re: Can't enter data in related table

In the attached db I used the wizard add a sub form for the notes. A sub form is usually used for the many side of a one to many relationship.
I have changed the main forms DataEntry property to NO...
Forum: Forms 04-09-2018, 03:20 AM
Replies: 9
Views: 219
Posted By bob fitz
Re: Stop save when close or new button

As I said in my previous post, you need code in the form's Before Update event which would cancel the update if validation fails
Forum: Forms 04-09-2018, 03:00 AM
Replies: 9
Views: 219
Posted By bob fitz
Re: Stop save when close or new button

you could use the form's Before Update event to catch attempt to save the record and then cancel the update if the record should not be saved.
Forum: Forms 04-01-2018, 11:24 PM
Replies: 12
Views: 245
Posted By bob fitz
Re: Automatically show remark comment in textbox

Use quotation mark at the start and end of the text."1) Please State:
2) Shrinkage: Maximum W: L : Twist:
3) PP sample -"
Forum: Forms 03-26-2018, 01:13 PM
Replies: 3
Views: 121
Posted By bob fitz
Re: Qry locked for editing in subform

I may misunderstood what you're saying but I don't think you can update a query that summarizes data.
Forum: Forms 03-25-2018, 09:51 AM
Replies: 11
Views: 241
Posted By bob fitz
Re: Form with datasheet AND single record view: Add a record ONLY in single record vi

Set the Allow Additions property of each subform as required
Forum: Forms 03-18-2018, 10:20 AM
Replies: 8
Views: 373
Posted By bob fitz
Re: Form/Subform Help

Can you post a copy of your db
Forum: Forms 03-18-2018, 01:59 AM
Replies: 6
Views: 208
Posted By bob fitz
Re: Search Button Help in Form

Take a look at the form called "SearchForm" in the attached file. I have used the code supplied by Ranman256 to apply a filter to the sub form after a selection is made in each of the combo boxes.
Forum: Forms 03-11-2018, 02:12 AM
Replies: 8
Views: 373
Posted By bob fitz
Re: Form/Subform Help

You could filter the sub form after selection of each of the combo boxes.

I have attached a db to illustrate how this might be done. It uses data from Northwind and the form and control names...
Forum: Forms 02-27-2018, 11:55 AM
Replies: 8
Views: 185
Posted By bob fitz
Re: Combobox with two bound columns?

Why use a combo box. You could use a text box that uses DLookup() as its Control Source to return txtDescription
Forum: Forms 02-22-2018, 09:12 PM
Replies: 15
Views: 393
Posted By bob fitz
Re: Link parent to child fields

Not usually a good thing to save calculations to a table. Normally better to do the calculation whenever and wherever it is needed.
Forum: Forms 02-22-2018, 03:45 AM
Replies: 15
Views: 393
Posted By bob fitz
Re: Link parent to child fields

Put a text box in the subject forms footer section to sum the calculation. This text box can then be referenced from another text box on the main former or the other sub former to show it's value
...
Forum: Forms 02-22-2018, 12:06 AM
Replies: 15
Views: 393
Posted By bob fitz
Re: Link parent to child fields

Can you post a db which shows the problem
Showing results 1 to 25 of 500

 
Forum Jump



All times are GMT -8. The time now is 11:18 AM.


Microsoft Access Help
General
Tables
Queries
Forms
Reports
Macros
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Sponsored Links

How to advertise

Media Kit


Powered by vBulletin®
Copyright ©2000 - 2018, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World