Search results for query: *

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

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

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)

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

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

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

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

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

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)

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],","))) & " " &...

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

thanks there, just what i needed :o)

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)

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

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

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!

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

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

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

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