Search results

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.

Great, thanks everyone, I haven't tried it yet, but thanks for your help.

HI, I have no doubt this is something very straighforward I cannot see, but when I try to comile my Db, I get an error saying; Compile Error: Label not defined. I've checked through, but cannot find the problem, it tells me "Resume Exit_cmdEndAfterCalendar_Click" is the line causing...

Hi, code noobie, so would love some help here. I have a form with several controls (mostly txt and chk). When I click a cmd, I have set some of the controls to Visible = False and some to Visible = True depending on what the user needs to see at the time. What I'd like to do, is if the...

Great, thanks for that. I hate to be 'that guy', and without your help I wouldn't have found it, but what worked was "List Width" not "Column Width", it was a few more down the list in the Format tab. Sorry, I don't mean for that to sound rude or ungrateful, I just thought I would point it...

Hi, I have a combo box on a form, but the data in the combo is wider than the object on the form, so some of the details are cut off when you scroll down. What I'm wondering is, can I make the cbo object on the form a smaller size, but when I hit the dropdown arrow, the choices appear in a...