Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. simmsey

    Using Excel macro code in Access - please help!

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

    How do you

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

    Capture Page Number from Access Report

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

    Default Administrative Password for system.mdw?!?!

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

    Default Administrative Password for system.mdw?!?!

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

    challenging update query

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

    Passing parameter from vba code to report based on query

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

    Login ID idea/problem???

    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?
  9. simmsey

    Cheeky Code

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

    DBase access with VB6

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

    DBase access with VB6

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

    Office & remote access

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

    How would I write this SQL in a Function

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

    Office & remote access

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

    VBA - why???

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

    Set a variable equal to Null

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

    Set a variable equal to Null

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

    Cash Drawer Signal for EPOS

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

    DBase access with VB6

    ...P.S. The Code I've tried using (incase it makes any difference) is: Private Const connectString As String = "Driver={Microsoft dBASE Driver (*.dbf)};" & _ "DriverID=277;" & _ "Dbq=c:\simms\dbf26\;" & _ "Exclusive=No;&quot...
  20. simmsey

    DBase access with VB6

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

Part and Inventory Search

Back
Top