Search results for query: *

i have the following code which adds an entry to the calander in lotus notes. The problem i have is that unless i turn off the alarms feature from within Notes i get the alarm dialog box pop up when the entry is added. This i supposed to be automated so i dont't want to have to manually set...

How might I get the user to input the date and time easily. I have tried having seperate controls for time and date but can't combine the values to save in one date/time field - DoCmd.RunSQL "INSERT INTO tblbookings ([StartDate],_[EndDate],[UserID],[ResID],[FileLocation]) VALUES...

I have a query as follows - SELECT Format([StartDate],"mmm") AS Month, Count(*) AS Bookings FROM tblbookings WHERE (((tblbookings.StartDate) Between #12/31/2004# And #12/31/2005#)) GROUP BY Format([StartDate],"mmm"); I want to order the results by month but when I try the list is in...

I am trying to create a bar chart that shows resource usage over a year. I have a crosstab query that totals resources used for each month of the year. I want this info displayed as a chart but the wizard tells me i can't have more than 6 fields. This is a problem as there are 12 months in a year

On the M$ site it says yes, but i have just recieved the software package and it doesn't mention xp in the requirements on the box.

This could just be a syntax problem. When my main form loads I want a popup form to open if a query returns any results. I'm not sure how to call the query properly. Private Sub Form_Open(Cancel As Integer) Dim stDocName As String Dim stLinkCriteria As String subfrmFutureLoans.Requery...

I just used M$ new antispyware program and it found zipdll.dll was infected with a commercial keylogger (Actmon). I have used Credit and debit cards on this PC. Should i be worried. I am on a comapany network behind firewalls. Could my data have been stolen? i have since installed zone...

I have a worksheet that calculates the percentage discount given off a standard rate (£) if the amount(£) of discount is changed. If the discount amount (£) changes, the percentage changes (the percentage also changes if the standard rate is changed, this is what i don't want). I need the...

Is this feasable. Would performance be poor. I have been asked to come up with a plan for replacing the hard drives in our server. We only have one server on site (for file and print). My boss wants the OS system drive mirrored as well as another, data only, drive to be mirrored. Jaydeebe...

I have been tasked with upgrading the hard disks within a windows 2000 file and print server. I am trying to work out how they are connected to the controllers. There are 4 basic disks installed and the hardware manager shows 4 SCSI controllers. Can i find out through windows 2000 which disks...

Has anyone done this? I use Ghost 2003. I encountered problems when cloning win2000 & office 2000 because of the way win2000 registers programs. I would like to know if there would be a problem with cloning win98 & office 2000. I have to use win98 because of legacy applications still being...

I was asked if I could make a message flash on the screen to warn users. I achieved this with this code attached to the form timer property. Private Sub Form_Timer() Counter.Value = Counter.Value + 1 If (Counter.Value Mod 2) = 0 Then Box23.Visible = True If Not (Counter.Value Mod 2) = 0 Then...

I'm not sure if this is true but users complain that when they seem to have saved a particular excel file, on opening again the changes have been lost. anyone experienced this? Jaydeebe BSc (hons) MCSA 2k MCSE 2k

The following code creates a record set from a table and then takes a booking (two dates,start and end) from a form and compares to see if they overlap with any previous bookings. Currently it just returns a message if the booking overlaps (or writes a new record if no overlap) but i want to...

I have been trying to figure out how to compare a booking entered on a a form by a user with all previous bookings. As long as they do not overlap I would like the record saved. If they do overlap the user will be informed and make another selection. At the moment I am trying to use CASE to...

I use a custom dialouge box to take two parameters (postcode & storename) from a user to run a query report. It works fine, handels null responses and wildcard input (on the postcode), but for one thing. When a user puts in a postcode that doesn't exist (ie. there is no store of that name with...

I am making a resource scheduler. It currently asks a user for input and then asks them to confirm the details. This is where it saves the record. I would like to check if the times of the booking overlap with any other bookings for the same resource that have already been saved. How might I...

I have a subform that autotakes a value from the master form in a linked field. I would like that same subform to autotake another value from a control that is taken from a combobox (different table to what the master form is based on so it can't be linked as master/child). How can i do this...

I have a form with 3 tabs. I have made it this way so that it is easy for a user to follow the process in 3 steps. The first tab has a combo box which I would like to provide the value for a field on tab 3 automatically. The second tab already does this for a different field (by using the link...

I have a table that contains a storelist and another that contains postal sectors and their longitude and latitude coordinates. I have made an Excel spreadsheet that calculates the distance between two postal sectors based on their longitude and latitude coordinates. I would like to convert my...