Search results

I had a similar problem recently. I have a linked excel file but I need to append it to another table each time the excel file is updated. But the append would not work. In the query I appended this instead cstr(nz([MyExcelFileName].[MyColumnName],"") The meant that whether I had...

The query returns records relating to clinical trials matching text the user searches for. Most fileds will be different for each record, but there's one field, like a "Category" that may repeat several times. The nature of the task is that some users will be very focused on the Category and...

Hi, Thanks a lot for your help. I didn't think you could have a subform in a continuous form, but it seems people have got round that by putting it in the header or footer (so I've learned something potentially useful already:)) I've tried that and I can see it kind of works, but it's not...

Hi, I have a nicely formatted report, but I want to have a clickable event. I'm using Access 2003 and the IT dept has no plans to upgrade to Access 2007. So I searched a bit and found this thread, where the suggestion is to create a form that looks just like the report. So, I've made a start...

Hi, I'm far from being an expert at this stuff, but I can see square brackets in your FROM statement. As far as I know square brackets are used to define fields which have a space [in the name] and not as part of the SQL syntax. Try replacing them with round barckets and see if you get the...

Thanks so much - I was beginning to fear I'd get no replies to this one. I don't want to interfere with the excel files (someone else uses them for a separate task) so I was hoping for an Access solution. I'm off work at the moment and won't have access to that data for another couple of...

Now those are funny!!

Hi, Not sure whether to post under queries, tables, or VBA but here goes: Each week I receive four excel files (relating to different years' data) from another office and I save them into specific locations/filenames. My Access2003 db uses those four spreadsheets as linked tables. Each file...

Gosh... I'm not that much of a regular here and just logged on to check something I know has been explained to me before. I'm shocked and saddened. As someone already said, David was really one of those guys who would take the time to make sure you understood and he was always full of good...

All this time and I never knew you coudn't add Nulls! Makes sense when I stop and think about it for a minute. Figured out how to use the Nz() function - eventually!!! I thought I could put it round the whole expression, but it appears you have to apply it to each field. Thanks so much!

Further information... A query using text fields runs fine i.e. Name: [Surname] & ", " & [Forename] returns a list of staff in the required format. So (I think) it must be something to do withthe data type, field size etc. of the numeric fields in my other table. Still can't figure it out!

Hi, I'm working from a colleague's office today, using her PC to set up what should be a very simple database. My table includes 5 fields, RequiredHours_Mon, RequiredHours_Tue, etc. Data type - Number; Field size - Double; Decimal places - Auto. I have entered a couple of test records and...

You live and learn...which is what I love about this forum. Thanks again!

Thanks so much - that works perfectly! I'm curious as to why it's needed though. Why doesn't the ".visible=True" line work by itself? I've dome something similar in another database and it works OK there without the me.repaint line. Pat

Hi, I have code that mainly consists of Do.Cmd.RunSQL "INSERT INTO..." There are 28 almost identical lines, differing only in table names, but split into three groups for the last three financial years. On the form that contains the command button, I have several hidden labels, so I inserted...

Thanks for the response. The "Kill" function? Sounds ominous! I'm not aware of that one. How would I implement this? It doesn't sound like it would go in the Access macro as I can't see that I would want to kill Excel having just launched it. Maybe you mean it should go in the Excel macro...

A hunter kills a deer and brings it home to clean and serve for dinner. He knows his kids are fussy eaters, and won't eat it if they know what it is. So he doesn't tell them. Jimmy keeps asking him, "What's for supper dad?" "You'll see", he replies. They start eating supper and his daughter...

Hi, Are you happy that the query is giving you the results you want? If so, then you need to create a new form based on that query (Form wizard > select your query). Then make your new button display that form. Or use your new form as a subform on your main form.

Hi, Yes I can see that I suppose. However, the plan is that there will only ever be one record in this table and navigation controls will be removed so that the user can't create another. My structure is as follows: tblActivation -> ActivationDate field only. One record only tblResearch ->...

Thank you both for those suggestions. I've tried to make them work but I failed. Maybe I'm putting the code in the wrong place, or maybe I'm missing something else which has not yet been mentioned. Two things to clarify: The form is definitely bound, although I have now also tried an unbound...