Search results

Thanks for you help Banana, but after scouring google for hours I finally found a solution, albeit a little messy. Heres the steps for anyone needing something similar in future. 1. Create you stored procedure in SQL e.g "sproc_MySproc" 2. Create a Pass-Through Query with this as the SQL...

OK the SQL does work if I hard code the parameter in. Is there anyway to have dynamic parameters for pass through queries?

no one can help?

I know there are existing topics on this, but im not sure if my scenario is the same. My entire Access App uses an SQL ODBC link for all its recordsources etc. But one Select Statement, (which runs fine as a SQL stored procedure) throws an error when I try run it from Access. Does...

I need a query to return the most recent price of a particular Product from each supplier it has been purchased from. This involves two tables. - TBLPurchaseOrder - TBLPurchaseOrderItem So I need; - Max(TBLPurchaseOrder.Date) - Where (TBLPurchaseOrderItem.ProductID = @ProductID) - For...

yeah bob I was coming to the understanding that the split function was creating an array, thanks for clearing it up.

perfect. thank you Wayne :)

Im looking to seperate the file name from a paths string. I assume you use the Split() Function to achieve this?? Ive tried somethig basic like this; msgbox Split("C:\Pictures\1.jpg","\") But I get error "Run-Time Error 13; Type mismatch" Basically I need a string with "1.jpg" only...

Is it possible to use Access to upload files from a client to a server? My scenario is for users to upload images of a product to a directory on our server. I will then store the root string of the images location in a field in the database. Ideally you can just browse for the file on your...

thanks for that code linq. btw: freaky, my name is BrettM also from Sydney Australia : /

appreciate the reply, thanks dudley

dudley, does this sleep interval prevent the PDF Distiller from crashing? If I try the loop with > 50 records it seems to get to about the 40th when Acrobat just crashes itself..

i ended up converting the ReturnedSerial field to same data type as Serial. But I still cant seem to get what I need. Does anyone know how to make this work?

I know these threads already exist, but I think my problem is slightly different. I have a query which will find duplicate entries for the same field, but I need a query which looks for duplicates across two fields. The problem being the second field (ReturnedSerial) is varchar(max). I get an...

I found Bullzip to be a good free PDF converter. That might suit your needs. Runs in Vista.

Im trying to construct a query which returns a field that has 21 different types of values. Is there a way to assign a text value to each numeric value when the results are displayed? Eg: 21 = "Local Sales", 22 = "National Sales", 23 = "International Sales".. and so on. Ive looked at the...

Found the answer on anouther forum, but here it is incase someone else would like to know later on: Put in the WHERE Criteria of your Select Statement. INT(YourField)

Wayne I found your method only removes the decimal point from [MyField]. It doesnt actually EXCLUDE the entire record. What I need to create is a Select statement which only returns records WHERE decimal point = .0. Not .1, .2, .3, .4, .5, .6, .7, .8, .9

Going on from there.... Can I create a Select statement which only returns a list of records that are xxx.0?? I.e exclude records that have .1, .2, .3, .4, .5, .6, .7, .8, .9 Thanks in advance

Thanks Mike works perfectly :)