Search results for query: *

Why arent you sorting by date in the Access report BEFORE you output to Excel?

In your form when opening the report using DoCmd.OpenReport there is an optional wherecondition argument. (look up OpenReport in help) You could put something like "[date]=#" & mydatecontrol & "#" The advantage of that over putting the form reference in the reports query is...

You should be able to use the Parent object i.e. parent.page in the subreport to return the page number from the parent report. The controls source on the subreport should be =[parent].[page] or in VB on the Format event for instance text1=me.parent.page

Sorry, forgot, to add to all that the system mda has an ID that must also be identical to the original. The only exception to this is if the system mda (mdw) was created without an ID (like the default) in which case you could replace it with another.

No this won't work. The system.mdw hold the user and group list, password information and userID'd That data is then used in the database file as reference for permissions. i.e. UserID ???? has permissions fro table1 etc. That means to replace the system.mda you'd have to know the UserID's...

I think you can use something similar to: UPDATE Table1 SET Table1.[logdate] = DMax("logdate","table1","[lognumber]='" & [lognumber] & "'"); That should run through the records and set the logdate to the max value of logdate found for that particular...

OR if you may be able to make use of DoCmd.OpenReport reportname[, view][, filtername][, wherecondition] and use the optional wherecondition argument to do whatever you want e.g. "[Date]="& date() This may offer a little more flexibility and allows the report to be used a number of...

Maybe I've read you message wrong but can't you just use the CurrentUser() function to return the user name? You can simply just run a query with the CurrentUser() function as a criteria?

I've just had a quick read through this thread and am slightly confused by the requirement. If I understand correctly you want to enter a value and then lookup that value to see if already in table, in which case get the other fields for editing OR if not already in existence to go to a new...

Thanks 1oldfoxman, From what I've seen the data in VB always ends with Asc 172. (e.g. first record returns 3 characters - ASCII 239,6,172) Unfortunately I can't see a way round this situation as the truncation appears to be happening at the ODBC level. I've tried a query with a statement...

Andy, Thanks for the help. It's fairly likely that the software used was not dbase. To provide more info the files I am trying to read are being generated by custom HMI software on an injection molding press. I do not know which language this HMI software was written in. This means that the job...

You could run an append query to add the records to the main database. That probably isnt a good idea over a phone line (or other remote connection) but would be fine if they are connecting to the network directly. When that has run successfully you just need to run a delete query. The...

As far as I can see what you are trying to do: return the count for a particular player number is done with scking's original post: txtBox = DCount("[Player_Number]", "tmp_tbl_dealing", "[Player_Number]=" & lngPlayer_Number by setting the variable...

Replication is a possibility. But be warned it opens up new possibilities for problems unless a strict structure is kept to. To do what you are suggesting you'd probably want to setup partial replicas on the laptops to avoid having security concerns of all your data on the laptop. You'd also...

I've been trying to resist getting dragged in but.. To reinforce what has already been said.. here goes. You shouldnt think of VB and Access Form methods as one or the other. They are complementory. The best thing is to find a useful balance using capabilities and advantages of each. VB is an...

Only warning is that Variant data types require more storage space. grnzbra your explanation for the need to set a variable to Null has me a little confused. I assumed you needed to represent a Long value (any + or - value within range of a Long) as well as represent when no value is assigned...

As far as I know you cannot assign Null to a Long variable. You need a Variant type variable which supports the Null condition. Simmsey

No direct experience with Access an EPOS but you should be able to use the Microsoft Communication Control on an Access Form to write serial data to a com port.

GetChunk may be the required method of accessing the type of data I'm after. Unfortunately the driver in VB is returning the field with type adVarChar and GetChunks does not work with this field type. It appears that the problem is at a basic level with the DBase driver in VB. Simmsey P.S. The...

MiggyD Thanks for the help. This looks very promissing. I'll have to investigate using GetChunk and give it a try. Thanks Simmsey