Recent content by pascaly

Hi Paul, yes, sorry, I should have been more clear, I mean into the table I'm importing to. Thanks for the tip, I'll give Dmax a try. Much appreciated.

I have a need to do multiple imports from Excel each week, each import needs to be individually identifiable. Is there a way to create a unique ID for each import I do (as opposed to each record). Thanks.

Hi all, looking for some feedback and advice. I have a Access backend linked to a SharePoint list. I run daily updates from several sources via the Access end to update the lists. One of the updates I run takes well over an hour (sometimes 1.5 hours, depending on the network). What I'd like...

I'm having the same problem. In the page footer, I have Date() in a text box. I want to put a label in front of it that says "Report Created on" in front of the date. I have no quotes and it's in a seperate box, yet when I view the report, I get a paramater prompt. Any ideas?

No, more likely they respect people's privacy and don't feel the need to brainwash others into thinking the same, closed-minded thoughts as them.

Sorry, I have nothing to add for the OP, but Dave, that is a fascinating bit of info there (regarding being divisible by 9). I just had to say something!

Thanks Coach, that sounds good. Plus the sub-form part is useful, a datasheet view would be perfect for the data I have. Thanks for your help, much appreciated.

Hi, I've tried to search around for a solution to this as I won't be the first to have asked about it, but I cannot think of a term to clearly define it and what I have searched for doesn't come up with what I'm looking for. We have a Db that holds data on multiple projects (Project A...

Something I do sometimes is create a "Clear Fields" button. Behind it's 'on click' event I put things like; txtstartdate = isnull txtenddate = isnull cboYourCombo = isnull etc etc This clears the form. However, this is better if the form is to remain open and users get multiple results...

Good advice? A woman wakes up one morning and finds her ****** is whistling. She asks her husband what he thinks, not having a clue, he suggests she goes to the doctor “I can’t go to the doctor like this!” she yells “All right, just ring the doctor then” her husband replies. So the woman...

Not sure if this is helpful, but I use a combo box with auto-expand on, that way, the user starts typing the name, it auto-completes, then if there is more than one person with that surname, all they have to do is select the name from within the partially completed list. My combo has about 400...

pbaldy! You did it. It worked first try. Thank very much for your help and that very quick response. Very much appreciated. :)

That was quick! I'll give that a try, thanks.

Hi all, I need to use the Switch function in a query. I have a query that gets the first letter of a Position Number (D, V, C etc. that works fine). Then, I take that query's results, and use it as a sub query in a second query. I then need to show a value dependant on what is returned...

razdanrahul, perfect! Thanks a lot for a very quick reply, made the change and now it's working fine. Very much appreciated.