Search results

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...

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...

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...

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...

I have a table with a numeric primary key field. Is it possible to create a select statement which returns a list of the records with the same whole number?? E.g 144.2 144.4 144.5 144.7 144.8 144.9 I need this as the Rowsource for a combo-box. Are there wildcards that I could use??

Im wondering if it was possible to run a Dlookup to find a value based on certain criteria such as non-primary ID field AND where the date is the earliest available. I know you can do Min(Date) in a query, but is there any soution for a Dlookup? Cheers..

I have created a Query which returns the correct results. But I need to assign the value of this query (its only a single field) to the value of a textbox on a click event. The query has a sum, which has criteria based on a related table, one of the criteria is dynamic. I have searched around...

Sorry if this has been covered before, I wasnt sure on the correct search word criteria. All I need is to format a textbox in a subform. The textbox is a integer data field E.g 1,2,3. If the text box is 1 then I want the text to display "In Stock", 2 "On Order. Etc.. Is this possible??

Ive been trawling the forums looking for what I think should be a basic problem. All I need to do is pass a value into a textbox of a new form on DoCmd.OpenForm. Should I be using OpenArgs for this? I have tried but everytime the textbox has no value assigned to it. DoCmd.OpenForm...

[Resolved] Custom Order By? Wondering if it is possible to order by particular values?? That is I have a column (varchar) named "Status" with values such as; Entered, Active, Completed etc (I didnt design the DB). What I need is to order by Entered, then by Active then Completed etc.. Is this...

Is it possible to create a form which display its data left to right, rather than top to bottom. I have tried using the different form layouts (tabular, columnular etc) but its not what Im looking for. E.g This is what I need; Heading 1 - Data1 , Data2, Data3, Data4, Data5 Heading 2 - Data1...

Ive have a continuous sub form with several combo boxes on each line. My problem is that whenever I select a value on one combo box, the combo box on every line updates. Is there a property or someway around this, or is it just not worth my effort?