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

    Passing parameters from forms to queries in VBA

    Okay, how would I go about that? I've done direct SQL thru VBA,a nd outputting simple queries to e-mail with VBA, I didn't think there would be much difficulty in passing a parameter from a control that is already open on the form...
  2. shanedavid1981

    Passing parameters from forms to queries in VBA

    Hey, I'm a bit stuck as to how I would pass a parameter from a form to a query in VBA... look at this: Private Sub Command5_Click() Dim xlApp As Excel.Application Dim xlSheet As Excel.Worksheet Dim xlWorkbook As Excel.Workbook Dim acQuery As QueryDef Dim objRST As Recordset Dim strQueryName As...
  3. shanedavid1981

    e-mail automation... including query results

    I have automated an e-mail process in access that will e-mail certain people requesting login activation, but I need the login list from a query including in this email... how can i do this? :o)
  4. shanedavid1981

    assign values from one table to another

    Hey, another little problem :o) I have one table for inductees, and another one for seasonal Unix logins to assign to these Inductees... How would I be able to take the next sequential 'X' amount of records from the logins table and assign these values in sequence to the list of inductees...
  5. shanedavid1981

    deleting duplicate records

    hey :o) I have a table for inductees for my organisation, and agency registers are imported into this as we receive them... The problem is that the agencies tend to send updated registers frequently, so creating duplicate entries. My system assigns unique ID numbers for each record imported...
  6. shanedavid1981

    requerying data on a tabctl subform

    It's okay, my bad, I forgot to rename the subform when i recreated it ont he TabCtl page... all sorted...
  7. shanedavid1981

    requerying data on a tabctl subform

    Hey, How would I requery a subform on a tabctl page? Where I used to have the following do the work: InductionAssistSub.Requery I now want to have this subform on a tabctl page, so altered the code to: TabCtl8.signin.InductionAssistSub.Requery And now I get error messages... signin is the...
  8. shanedavid1981

    background colouring for selected rows on form

    Hey, I'm looking to be able to color a selected record row either red or green dependant on whether a toggle button is set to true or false on the record in question... is there a way to do this? At the moment, if i toggle this button on any row, it colors the whole form background one color...
  9. shanedavid1981

    Selecting and Importing .xls files at runtime

    Hi guys, I haven't done this for a while, and thought I would try asking here first... how would I be able to call the windows Open File dialog box to select an xls spreadsheet for access to append to a table at runtime? :o)
  10. shanedavid1981

    InStr function?

    Hi guys, I'm trying to turn a name around in a query from Lastname,Firstname to Firstname Lastname... I've toyed with the InStr function to do this, but it somehow garbles up my output from time to time... this is the code that I used: FName: (Right$([Name],InStr([Name],","))) & " " &...
  11. shanedavid1981

    web based tables importing into access

    Hi guys :o) This is an issue I have queried about before, and I'm sure many of you have scratched your heads about this... I'm trying to get access to automatically import information from a web based table on a .cgi page by firstly accessing the link in IE and then importing the data from the...
  12. shanedavid1981

    closing db connections

    thanks there, just what i needed :o)
  13. shanedavid1981

    closing db connections

    hey, thanks for that :o) how would i get a control on a form to constantly keep in current time with the system? It's not something I have had to do before... I can get it to take a snapshot of the current time, but not sure about refreshing every x minutes or something... Thanks :o)
  14. shanedavid1981

    closing db connections

    I am currently creating management reporting functions available through Access, and need to update the data tables on a daily basis. Is there any way I can close access to the database at a certain time each day (say, 10am) for 10-15 minutes while this is done? Sometimes managers (being...
  15. shanedavid1981

    queries to make exclusions

    thanks :o) i also remembered i could cheat by modifying an unmatched query between the supervisor and workfoce listings, hehe!
  16. shanedavid1981

    queries to make exclusions

    hi, I'm looking to write a query that will exclude records from a main workforce table that are listed in a supervisor table, so that managers/supervisors wouldnt be listed from the workforce table in my mainstream reports... is there an easy way to do this? thanks!
  17. shanedavid1981

    finding similar records

    Hi, I have a problem thats been building up for quite some time now... I have just been given a huge QA database to oversee and manage, but the auditees have had their usernames manually entered all this time... you know whats coming... I now have 100,000 + records where the usernames entered...
  18. shanedavid1981

    leap year stuff

    hey, thanks for a quick reply... how would i code this in then for redundancy purposes? for example, the normal 365 day calendar has small boxes called Box1..Box365 and i plan to use an array to read data in from a table and colour code the boxes if there is a code associated with that day...
  19. shanedavid1981

    leap year stuff

    Hi people :o) I'm wondering if anyone knows this, but does the leap year day in the year get numbered in sequence with the rest or does it become day 366? I'm programming a calendar matrix on screen that will represent each block as a certain colour for whatever code is associated with it, and...
  20. shanedavid1981

    Excel date problems

    Hi everyone, I seem to have an ongoing problem... If I get a report from a cgi page into excel (for importing into access), and the cgi page contains dates in american format (mm/dd/yyyy), excel will try and use mm/dd/yyyy as dd/mm/yyyy, rather than change them all around. So, put simply, the...

Part and Inventory Search

Back
Top