Search results

Muchos Gracias gurus..... Much appreciated.....

Good morning site gurus ! Quick questions, working on a contact database and would like to include a pic of the business card in the contact form. 1. How would I display the picture in the field when form loads? 2. How can I limit the size of the file loaded so no pics about 100mb are loaded ...

Thanks a lot mate, I'm seriously struggling with " and 's when it comes to SQL, will learn one day....

LOL... Absolute pure luck my friend......

Sorry how do I do that? Im not that great when it comes to SQL

Hi guys, I have this code for password change on a form, but cannot get it to work, keeps asking value for intUserID on execution, where as I already have assigned in green highlight , cboEmployee is a unbound filed on the form WHere am I going wrong? Private Sub Command147_Click() Dim...

Holy cow....... Thank you sir - sometimes the simplest solutions work.....

Thanks Arnel, that looks awesome but, my aim is not to save the file somewhere, just put the attachment from tblADCB to the unbound field on the form called ADCB With my limited experience on VBA, I extracted below, which I assume takes the attachment and saves it, but instead of saving, I want...

Used Dlookup but didnt work, also placed in on load event to populate, gave runtime error 438 Object doesn't support this property or method FOr this field, there's no write back, single record, holding a template file

Hi Arnel....... Its an excel file - i just want user to open the file, no save back add code to the Click event to Extract - what would be the code, not that expert like you guys , yet.....

Good morning/afternoon/evening guys, I want to place a field (unbound) on my form (Unbound), which will display a record from another table which contains one record with an attachment, to serve the said file as template so user can open, use and save somewhere else How can I link this unbound...

Thanks guys, as I didn't get anywhere with multiple criteria, I built in the fixed element into the query and Dsum'ed with the projectName - now it works, not the ideal way but problem solved for now

Nope, still no sugar....still #Name?

I can't see any misspelled field names, and query is working as it should be - Dsum should give total of 2 seeds, maybe one day ;)

By the way, Total is a calculated field in the query, would that make any difference?

Thanks but no sugar yet...Filed comes up as #Name?

Hi Guys, Trying to sum fields based on a ID from a form, and a text field, fixed - my version is below - what am I doing wrong? =DSum([total],[qrybudget],"[ProjectName] = " & [me].[ID] & " And ctrBudgetType = 'Seed'") ProjectName is a number field, and ctrBudgetType is a text..... Thanks in...

Thank you guys....... I need to buy you guys few beers ;)

Hi Guys, Its me again....... I have written below SQL to list all contracts with invoices to run a report, but unfortunately, it only results contracts with invoices attached to it, but I need the zero ones listed too How do I achieve this? SELECT tblProjectContracts.ProjectName...

theDBguy, you are a life saver !!! I just wasted hours on this...... Thanks man!