Search results

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

hi Ecniv you have to treat my piece of code as a bid of struggle :) anyway, yes I wanted to open a query as recordset and loop through the records, if u have any suggestion how to do this in civilised way, shoot me. You gave a good hint with the update query, though. Cheers mate Mark

hi there, unfortunately not this line: rstName.Fields("Id_seti") = id should save this in a table, so Id_seti it's a field in a table

hello again, I'm in trouble again and need help, I have a query which has a Id of set and particular pieces for it. On the form that I've got user selects the Id of set and gets all the pieces which are in it. Each piece has its own report which is printed afterwards. What I want to do, is to...

Hi all, The thing which I am strugling with now is some sort of report pages counter. On the report I have a textfield where I want to have a "running number". This number will tell user what is the number of this particular report, I mean it will show how many report was printed. I am...

Thanks you guys for all yr replies, I've got it, the solution was easier than I thought it would be, Public Function ElapsedHrs(DS As Date, TS As String, DE As Date, TE As String) As Single 'Returns elapsed hrs with minutes 'DS = Start Date 'TS = Start Time in 24 hr (military) format hh:mm...