Go Back   Access World Forums > Search Forums

 
Showing results 1 to 25 of 500
Search took 0.14 seconds.
Search: Posts Made By: bob fitz
Forum: Queries 11-19-2019, 01:01 PM
Replies: 17
Views: 274
Posted By bob fitz
Re: Undefined function 'Nz' in expression

Sorry for my ignorance but I don't understand this question. The message I posted is the message that I get when I try to open any query that uses the Nz() function.
Forum: Queries 11-17-2019, 09:02 PM
Replies: 17
Views: 274
Posted By bob fitz
Re: Undefined function 'Nz' in expression

References are fine but still can't use Nz() in any query, in any db :banghead:
Forum: Queries 11-17-2019, 12:53 PM
Replies: 17
Views: 274
Posted By bob fitz
Re: Undefined function 'Nz' in expression

I don't think that I have a problem with Nz() in the form.
I get the error when I try to run the query.
Forum: Queries 11-17-2019, 11:11 AM
Replies: 17
Views: 274
Posted By bob fitz
Undefined function 'Nz' in expression

Can anybody explain why I get the error message in this thread title when I try to open query1 of the attached db. The SQL for this query is:SELECT Table1.ID, Nz([Num],0) AS n, Table1.txt
FROM...
Forum: General 11-15-2019, 03:48 AM
Replies: 14
Views: 760
Posted By bob fitz
Re: error 3340 ‘Query is corrupted

See this thread: https://www.access-programmers.co.uk/forums/showthread.php?t=307918
Forum: Queries 11-15-2019, 12:35 AM
Replies: 29
Views: 305
Posted By bob fitz
Re: Circular reference when using filed name in IIF query

Try the following SQL for your query:SELECT tblCompany.Mobile AS M, tblCompany.PersonalCellular AS PC tblCompany.CompanyName AS Company, tblContacts.ContactName AS [Contact Name], tblContacts.Title...
Forum: Queries 11-14-2019, 03:15 PM
Replies: 29
Views: 305
Posted By bob fitz
Re: Circular reference when using filed name in IIF query

Can you post a copy of the db with the table and your query.
Forum: Queries 11-14-2019, 02:18 PM
Replies: 29
Views: 305
Posted By bob fitz
Re: Circular reference when using filed name in IIF query

Can you post a copy of the db wit just the necessary table(s) and query
Forum: Queries 11-14-2019, 02:05 PM
Replies: 29
Views: 305
Posted By bob fitz
Forum: Queries 11-14-2019, 01:57 PM
Replies: 29
Views: 305
Posted By bob fitz
Re: Circular reference when using filed name in IIF query

Your Welcome ;). Let's leave the cigars unlit until we've heard from the OP though :D
Forum: Queries 11-14-2019, 01:42 PM
Replies: 29
Views: 305
Posted By bob fitz
Re: Circular reference when using filed name in IIF query

Try:
SELECT YourTableName.Mobile AS M, YourTableName.PersonalCellular AS PC, IIf(IsNull([M]),[PC],[M]) AS Mobile
FROM YourTableName;
Forum: Tables 11-12-2019, 12:44 AM
Replies: 9
Views: 121
Posted By bob fitz
Re: Locking problems altering a table ??

I would recommend you to read the following link: https://www.excelguru.ca/content.php?184

This forum is not a store. We do charge for the knowledge and advice given. If one was running a...
Forum: Queries 10-29-2019, 04:28 AM
Replies: 6
Views: 143
Posted By bob fitz
Re: Query Criteria - text only

If it would be possible, just change the WHERE statement to:

WHERE (((IsNumeric([ALFA]))=False));
Forum: Queries 10-29-2019, 03:30 AM
Replies: 6
Views: 143
Posted By bob fitz
Re: Query Criteria - text only

Try:
SELECT Table1.ALFA
FROM Table1
WHERE (((IsNumeric([ALFA]))<>True));

You will need to replace "Table1" with the Name of your table.
Forum: Modules & VBA 10-29-2019, 03:20 AM
Replies: 5
Views: 118
Posted By bob fitz
Re: NotInList Problem

Well, I must have used similar code literately thousands of times in the last 25 years which is why I was so puzzled. It wasn't till I started to rebuild the form (because I thought something must...
Forum: Modules & VBA 10-29-2019, 01:15 AM
Replies: 5
Views: 118
Posted By bob fitz
Re: NotInList Problem

Well, I may be septic but I'm certainly not psychic :D. I had a little peek at Who's Online ;)

The INSERT statement was actually commented out in the posted code but doesn't show very well.

To...
Forum: Modules & VBA 10-29-2019, 12:18 AM
Replies: 5
Views: 118
Posted By bob fitz
Re: NotInList Problem

Solved !!

I was indeed having a "Senior Moment". :o
I was trying to use the code in a combo designed to find a customer record rather than the combo which is used to create a new record for a...
Forum: Modules & VBA 10-28-2019, 11:32 PM
Replies: 5
Views: 118
Posted By bob fitz
NotInList Problem

Can someone please look at this and tell me what I'm doing wrong.

The code adds the NewData to the table but I get a message which tells me, "The text you entered isn't an item in the list"
...
Forum: Forms 10-22-2019, 06:33 AM
Replies: 66
Views: 673
Posted By bob fitz
Re: Autofill

Yes. Thank you. I've seen the new post. I shall refrain from getting involved with that. Clearly my help is not wanted and to be perfectly honest, I rather not help someone with his attitude :)...
Forum: Forms 10-22-2019, 06:08 AM
Replies: 66
Views: 673
Posted By bob fitz
Re: Autofill

I have looked through page 1 and I am unable to see anything that makes it clear where the second subform is, as l thought would be the case. Your reluctance to answer straightforward questions makes...
Forum: Forms 10-22-2019, 05:58 AM
Replies: 66
Views: 673
Posted By bob fitz
Re: Autofill

Thank you Colin. At least I'll be able to reply to TPS now.
Forum: Forms 10-22-2019, 05:05 AM
Replies: 66
Views: 673
Posted By bob fitz
Re: Autofill

What is the post number in which you said that the second subform was on the main form
Forum: Forms 10-22-2019, 04:56 AM
Replies: 66
Views: 673
Posted By bob fitz
Re: Autofill

And how that is done will depend on where the second subform is.
Forum: Forms 10-22-2019, 04:49 AM
Replies: 66
Views: 673
Posted By bob fitz
Re: Autofill

So, is this second subform,
Another subform on the main form
Or a subform on the first subform
Forum: Forms 10-22-2019, 04:34 AM
Replies: 66
Views: 673
Posted By bob fitz
Re: Autofill

So, the requirement will be to have a TextBox on the sub form. The textbox will show the text of the selected item from the combo box on the main form and the textbox will be locked or disabled....
Showing results 1 to 25 of 500

 
Forum Jump



All times are GMT -8. The time now is 07:20 PM.


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

Featured Forum post


Sponsored Links


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