Search results

Hi Guys I'm trying to get this Update query to work, but it fails with the addition of the second parameter in the 'Where' clause DoCmd.RunSQL "UPDATE Tb_DistinctReceipts SET Tb_DistinctReceipts.TotalQTY = '" & POsum & "'WHERE PurchaseOrder = " & PO & " AND Where LineItem = " & Line & ";"...

Re: Passthrough query returns records >255 chars, how do i update memo field in table Hi Rookie, no Varchar is defined. It's a simple select x from mytable(on server) where z = AA I've got vba creating the passthrough query As i say, the whole result is returned, but across two lines in...

hi all, i have looked around the forum for an answer to my problem but have not found a solution, so here goes! I'm using a passthrough query to collect some text data off my works sql server. The fetch works fine however, the text string result is often greater than 255 characters long. I...

Hi all, i have a textbox on my form and i have set it's default value to show Date(). i.e 14/01.2009. Now this displays fine in my version of Access 2003 and works ok on ACC2007, however, i have two colleagues in my office who are running Acc2003 but their date textbox displays #Name?. Is this a...

Lineinput works great! Thanks guys

Hi guys, a simple problem. My text file contains 1 line of data, i simply want access to open the text file and dump the contents into strtemp. My code below doesn't seem to do that. Please can someone help? TmpFile = "c:\results.txt" Open TmpFile For Output As #1 Input #1, strtemp...

Thanks guys, but unfortunately still no luck! Attached is a screenshot of the suspect binary column (t_text) within the table when opened up in Access 2007 and 2003. As can be seen, It appears Access can't interpret the string correct, and thats probably where its going wrong. A mate of mine...

Thankyou so much for the responses guys, i have tried the code samples as suggested, but i am still struggling to get this function to work. We have a bit of script code that does work, but i am trying to convert it to work with Access. I think the CAST function is where everything is going...

Hi all, does anyone have a function that will convert a binary string into ASCII using vba or sql. I'm not sure if this can be done in Access as i can't find any resource to do it on google. Any help appreciated!

Thanks! Exactly that :)

Hi all, i'm using this SQL statement to attempt to update my Emailaddress field in my table "tblrecord", however it doesn't seem to work. Here's the code Dim dbs As Database Set dbs = CurrentDb dbs.Execute "UPDATE tblrecord SET [EmailAddress] = '" & EA & "' WHERE[PurchaseOrder] = '" & PO &...

Yes! it works ken, thanks, but i need to make the totals show at the bottom, as close to the footer as possible. At the moment it shows under the last item on the PO, which could be anywhere. Any ideas?

Hi all. I've created a simple purchase order report, that includes a header and footer graphic (jpeg). The report works fine but i want to be able to display my total price and tax figures on the last page of the Purchase order report .At the moment i've entered the two fields in my footer (two...

I sorted it. I used a format of 00.00;0 in the report text property. Thanks guys

Tried that! doesn't seem to work. i know its simply,just can't figure it out!

Hello, As an example, my query is returning a price in the format of 47.1 47 but i want to format it in the format of 47.10 47.00 how do i do this please?

i'm totally new to SQL so please bear with me! I've basically linked some tables from my works SQL server to my Access application. Everytime i exit my Access app and go back into it, a dialog box come up asking me to enter username and password for the server, which i enter and it gives me...

Problem with attachment when sending through Outlook Hi All, I'm using this bit of code to test the feature of sending an automated email to Outlook via MS Access on the click of a button. The bit of code seems to work, however it is putting the attachment right bang center of the email body...

Thankyou so much! just one problem though, Using the code you gave me, the data in "period" is not in logical order when i run the query e.g i have APR 08 first then AUG 07 then Aug 08 etc. I tried doing a sort but no luck. The code i used is: SELECT test.Part, Format([PostingDate],"mmm yy")...

Hi all, this probably an easy request, but I’ve been scratching my head for a few hours to sort this little problem I have. Below is a scaled down output from my query, I’d like to be able to plot a line graph in a report, that would show Y axis as “CountOfQTY” and X axis “Posting date” , but in...