Search results

Good afternoon guys/gals, I'm trying to assign a value to a text box on form load with below code but Access tells me I can't.... As usual, what am I doing wrong? Also tried .value, same error..... Me.Text981 = DLookup("[CompanyName]", "tblVendors", "[ID]=" & Me.VendorName)

Found it..... It's bloody quotes again...I'm never gonna learn this !!! Have a fantastic quote error free day chaps !

Hi Guys, Trying to add a record to an existing table from the form data, which is already linked to another table and of course, failing spectacularly !!! Below is my simple code and I am getting a syntax error in the HotelName field to start with, probably next ones will also follow ;) Where...

Complication.... Agree, and already removed the picture, light gray is the new background ;) Was just wondering why buttons would stop , but hey, life continues....... Thanks,

HI all, in order to hide the gray Access workplace, I created a form, maximise it with a picture but after this none of my form buttons for close/open reports etc are working Background image form is simple, no buttons etc, not modal/pop-up and other forms open on top of it Any idea what am I...

Ahhh now I see where I was going bananas, was trying to export via docmd.TransferSpreadsheet ! Much to learn, much to learn...... Thank you kindly sir

I've been trying my best not to ask and try to figure out myself but nope.... How can I export to Excel? Thanks, Erol

Man....I don't now how I can thank you more...... Life saver ! Thank you !

If I can trouble you once more again, how can I transfer the data to a report? In the original DB, I have a report designed which links to the form, but not sure how I can replicate your solution in the report?

This is cool sir, Much appreciated, life has a meaning now :)

ITs 365, so should work - I shall try your solution

HI Mate, Thanks for above update, If you look at the Form1 design, I placed 5 unbound fields for the output, how do I link the query output to these? After updating with above, there are no fields available under 'add existing fields' ? Erol

Hi Chaps, Me again...... I have resolved few steps in my Crosstab query issue, now can filter for 2 fields ! But I need more.... As usual.... I have attached my sample DB, and this is what I need to do but have no idea how to Table tblSalaryScale contains salary details by...

Nope, no go for this one as well Strangely, this one, although provided hard coded, still opens up a window asking where to save, this is something new in this saga....

OK, let me try this one also....

All checked, mapped correctly - all works on my machine, nad few others and does not work on majority...... I gave up on OutputTo - my hair went gray !

but that would be manual work - thing is, after creating the PDF, I'm also adding a record to a table with hyperlink to the file location So, I need this to be 100% VBA

Hi guys, After spending days searching for a solution for the OutputTo save a PDF file on a network drive failing miserably, I give up..... Now, I need to find a solution, ie a VBA code which does the same, to create a PDF, name it as per the code and save it on a network folder provided in...

Hi DocMan ! Got the error message happening in the background, How can we fix this sir?

Hi Docman, Issue lays with PDF on the other PC , so i'm totally ignoring No 2, shizzle works as far as Im concerned..... Fullpath is going to be bit difficult as DB is runs with menus, protected etc and can't have the VBA side open, maybe I'll put a msgbox to see, but I don't think there's an...