Search results

cheers the code did work it was my fault, bangs head. was trying it on a copy of the form and hence the name for the form wasn't the same :) cheers all

huh, what do you mean check and substitute, if your asking if they are spelled the same then yes they are

it be a string I tried the first one and now I have a flashing #error the second one says #name

Hi All have been give the task of marinating a database but the column names have spaces and I don't want to change them as It may effect other parts of the DB but I have a dlookup that I would like/need to add but it just comes back with the ol #error here is my code =DLookUp("[Supplier...

ok but could i just not name the pics the same as ID number ? and what if you dint mind would the code look like ( using the best air code/back of fag packet )

Star, cheers

I have a simplish database whch i have made to keep track of my game collection ( and yes there are other optiuons but none did what i wanted ) so i have a simple search which in the below attached pictures you can see is my error and reason for this post, as i searched for the game 688 and...

i like that solution cheers

Fixed it, yippeee all i had to do was view the SQL and remove the DISTINCT from the below so now it looks like this INSERT INTO tblExtractData SELECT tblChargingTable.* FROM tblChargingTable WHERE (((tblChargingTable.AppointmentDate) Between Forms!frmMain!txtChooseFrom And...

very good

erm yes.... could you send me your workings and also how did you get the upc-a barcode or did you just create it on a web page and then paste it in ?

Afraid so see below attached showing the results and the query changed from append to select

Of course

Hi All have a slight issue and have searchd and it seems like it's a known bug, but cant find any fixes so have a table which has a memo field and is set ot rich text, which is fine as it shows all information as it should but then i have an extract data table as we need to run a report...

what would the befit of using PNG be over .jpg and eitehr way im still gonna have a white box

yeah just like to block some of the barcode off with an angled image

so no way i can make a non rectulanger image box

using this which uses a web api

Simple one which is eitehr a yes or no answer I am currently tyring to make something for someone, but wantedto try and a bit more pizzazz and wanted to shape the barcode so it would resemlbe a mountain like some of these do shaped barcodes but if i try and just plonk an image it just sits...

sorry for the tripple post but i have sorted it. i used the mid function and cut out the slashes to another text box and here is my code now Private Sub cmdQuery3_Click() Dim mypath As String Dim strReportName As String Dim sEmailTo As String DoCmd.OpenReport "Query3"...