Search results

Banana, Thanks for the pointers. I think I will investigate option 1, using append queries. Any general tips for Append queries? Citrix might be an option, I think they do use Citrix. I'll check that out too. Thanks again. Fraser

Hi, Woudl anyone be able to point in the right direction please. Is there an easy way to automate information copying from one database into another database (both with the same structure) using Access or do I need an import tool? I have developed a database but I'm starting to requests for...

Seriously, that is quality! :) Thanks a million, now I know the correct syntax. I was trawling the internet and found many other code examples which referenced the .column(1) method but I just couldn't get the syntax correct. Fantastic, thanks again. I made a slight amendment to the code to...

Yes, you're right, it's a a lookup from another table. I tried the column 1 thing but it just crashes when running the code. I had high hopes though. I'm messing around with invisible text boxes and referencing those instead, but haven't quite got that working either.

Mike, yes, I'm using A2007, so I can go straight to PDF. Kiwiman, thanks for your code pointers. After blending that with my existing code, lots of trial and error and some expletives I have it working. The only annoying thing is that instead of combo box text I get the column ID number. I'm...

Thanks for the offer DevastatioN, I did do a but of creative editing and now have a pretty good icon, although it has a black background. Luckily my button bar is generally black so it blends in. If anyone else wants one, here it is....:)

I've been mesisng around iwth this all afternoon and I think I can get fields and date etc in the filename, at least they appear in the filename dialog. However, when I click save I get a runtime error 2059, can't find object. Basically because it looks for an object wihich is a combination of...

Actually pretty much there now with some messing around. :)

I'd love to. I have most of the ingredients here i.e. some nice images, png/jpeg/bmp files. However, I am restricted by my software choice on my work laptop. Basically I have Paint and Office Picture Manager to do picture editing. They are just a bit too basic even for that.

Hi, I have created a command button to open a report of a sepcific record, save/export as PDF and then close the report. This forum and Google were a huge help, once again. I'm stuck with the last part though. I would like to name the exported file using a unique reference in one of my form...

Hi, I have been (and continue to) trawl Google and the interweb, trying to seek out a nicely proportioned bmp file I can use on a command button for a 'Save as PDF' button on a form. So far none have fitted quite as nicely as the standard button dimension provided by Microsoft. Does anybody...

Great stuff, thanks for your help. Much appreciated. Working now.

Hi, Wodul anyone be able to tell me how to force a user to select one combo before another, posssibly with a message telling them to do so. I want them to have to select the first combo in a cascade rather than another with an unfiltered list. Thanks, Fraser

Fantastic! :) You have no idea how much this has been bugging me. Thank you very much, I'll update all four now. Fraser

Gents, I've tried exactly as suggested but can't seem to get it to work. Here's an abbreviated chunk of the database. The form is 'frmJSA' The tab is 'Job Demands' I'm trying to get this to work on four fields which require some form of weight value. The example I gave above was 'lifting...

Still haven't got this to work. Can somebodey confirm exactky which event I shoudl be using for this? I am trying AfterUpdate, but have also tried On Change and On Click. Without any sucess so far. It seems that having two options in the combo box is simple i.e. it's either one or the other...

Ok, this time the box remained enabled for all options. Sorry to drag this out, I hoped it would be fairly simple.

Hi, It does the same. It's enabled on form load for "O", but if I change it to any oother option it disables. It thinks about it and changes very briefly after a change but then just disables it and won't re-enable on any of the options.

I am trying to get a text box to be enabled or disabled according to one of five values in a combo box. Here's my code in the after update event of the combo box: Private Sub cboJD_lift_freq_AfterUpdate() If Me.cboJD_lift_freq.Value = "N/A" Or Me.cboJD_lift_freq.Value = "N" Then...

dk, Thanks, this looks like a useful site. There does appear to be a couple of potential examples on there so I'll give them a whirl...