Search results

Apologies to all. No offence meant. I just did not understand the protocol. It will not happen again. Rob

Good morning folks. I asked this question in the 'query' section of the forum, but so far I've had no luck. Perhaps some of the VB gurus on here can help. I have a query that has to look at the contents of five fields in the same table to determine if any or all has a null value. I can...

Dear mahenkj2 Many thanks for your prompt response. I have already tried to do the same thing as your sample query and unfortunately I found that it simply returns all of the values in the table no matter what the content of the field. I have deleted the columns in the query, leaving only...

Good morning folks. I have a query that has to look at the contents of five fields in the same table to determine if any or all has a null value. I can underrstand how to return records that all five fields are null and all five fields are not null, however I need to know if any records have...

Dear Plog, Wonderful! I'm sure that was one of the methods I tried. Obviously not. It worked perfectly. Doh! Many thanks Rob

Hello folks, after several frustrating hours, I'm almost on the point of giving up. Here is what I'd like to do in a Text Box on a report. The text box should be set to date() but I need to change the format and to add additional text so that the box will display Eg. "On this day, Tuesday...

Many thanks PBaldy and Peter, these are what I was looking for. Rob

I noticed that someone on here, some time ago, posted a link to a sample form that showed how to limit the items in a second combo box list based on the selected item from the first combo box list. Unfortunately I cannot locate the item, so could someone help? I have a form with two drop...

Hey Bob, it seems to have worked. Discovered one or two issues with the code, but I'll deal with them later. I just REM'd them in the meantime and now 'Complete Word' facility is working again. You are a star sir!

Indon't seem to have the option to debug - Project. In the Debug area of the VB Editor window there are several options but not Project. Am I looking in the wrong place? I am using Access 2010.

No, same problem. I'll go back to the last changes that I made to see if I can locate the problem there. Thanks Bob.

I have created a new blank dbase and I will import all the components of the effected one, Maybe this will help. I'll let you know.

Sorry Bob, I take that back. I just opened an old copy of my dbase that I had archived and it works without problem.

I copied my dbase to another computer and tried it there. Works perfectly. I opened a different dbase on the original computer and it had the same problem. It appears therefore that the issue is with either the computer or the programme rather than the database itself.

Sorry, that should have said 'Hello Bob'.

Hell Bob, many thanks for your prompt reply. I had a look as you suggested. The Auto List Members was checked. I unchecked and restarted. No difference. Do you think that I might have a virus problem? This has never happended before and was working as normal up until two days ago. I did...

Has anyone ever come across this problem before? Whenever I start to type any docmd...line of code the 'Complete Word' facility does not work, unless I start it manually. I have to do this repeatedly. It is very annoying and of course time consuming. I had not realised how much I had become...

Thanks for your advice Gemma. A bit complicated I think, but I'll certanly look into it. An automated system would be fantastic if it could be done, however manually updating EACH pc over a weekend day is achievable. I reallly don't imagine that the FE fuctionality for ordinary users will...

Wonderful Pat. All my questions answered. You're a star! Rob

Hello Folks, It is clear to me now that the way forward for my database is to split it. Thanks for all the information I have gleaned from here. I have a couple of questions though. 1. If each workstation has to have its own copy of the Front End, where is this stored? Is it held...