Recent content by Markvand

In Access -> External Data -> ODBC Database and then I'm choosing the user DSN source. I can't even get the window with tables, just timeout error.

Hello, I have an odd situation with ODBC connection in Access 2010. I can't link any tables to SQL 2005 due to timeout error. The strange thing is that I can easily get the data through ODBC with Excel. I thought it might be an issue with Windows 7 64bit and Office 2010 bit, but the same...

I have a query that shows a list from GPS software (car fleet management), unfortunately the software is not capable of doing a decent reports thus I'm trying to use its data and do it myself. The table structure is as follow: Car, Date, Time, Position. The time interval I have now is 1...

Finally got it work, Thanks a lot guys, much apreciated Cheers

G'day Jon, I've put date() + time(), and still can't limit the results only to latest date. I'm getting all the records sorted from the latest to the oldest, and what I want to have is only the lastest. The thing is I am using an append query where I'm assigning autonumber to each of item_id...

Brian, Thnx for reply, I've put date and time in one colummn: date() &" "& time() and still nothing, I don't know if this is a way. Any other suggestions are more than welcomed Mark

Hi all, I want to list only the latest records, thus I have total query, I'm playing around with this but somehow it doesn't work: I have 3 fields, print_id - PM in a table and autonumber date time I have a group by in print_id and max in date and time Please help

Now when you pointed that out, I will actually need just one, the other I have to store somewhere.

Hi Rich, The main form is used a search engine, user can enter or pick a set number and then can see alll the items included in this set on the subform (continous form). These two fields corespond to quantity and contract, as I wrote before these values don't have to be stored in a table. They...

Thnx for fast reply, Still nothing, once again it passes the value but it doesn't display it on the report

Almost there, Public contract As String ... contract = Me!subform.Form.Contract ' The text field is on the subform" - it works fine DoCmd.OpenReport "Metrics", acViewPreview, OpenArgs:=contract ' It passes the argument - works fine again On the report in the desired texfield I have...

G'Day Rich, I've tried with all the ways, still getting: Name?, it's doesn't recognize it. The field I want to get the text from is on continous form, 2 fields are unbound and the rest is bound to a query. Maybe this is a problem.

Hello, It's probably something simple, but I can't figure it out. I have a report based on a query, what I want to do is transfer the text entered in the form to report, I don't need to store it in a table I just want to print the report and forget about entered text. Any help would be much...

I've just used append query and it does the job, the simplest ideas are the best. Thanks again Ecniv, Cheers Doc :) Regards Mark

hello Doc_Man yep it is my problem, hopefully one day it will be better :), "If you open a recordset as myRS = db.OpenRecordset(etc etc), then you can do a myRS.MoveNext or refer to myRS.Fields("Name") and it has meaning." that's quite clear, but how would you get around examine records in...