Search results

Neighbour has got a new `puter which came with Office 2007 (without Access ) He needs Access to run an app for his business. He still has a copy of Office 2000 Pro. Are there any issues with installing Access 2000 alongside Office 2007. ? The app calls Outlook to send emails. Will there be...

Any thoughts on the reliability of running the above. only 2 or most 3 machines with front ends and back end on 1 of the machines Prob is site bisected by road David b

I am trying to email to a selected customer some data as an excel attachment. The following routine creates the email and attachment but the address needs to be added manually. The address is grabbed by this sql - SELECT Customers.CustomerID, Customers.EmailAddress FROM Customers WHERE...

I have a query which gets its criteria from a form. On the form is a combo which selects cust number and a text box selecting date. This works fine if both have data or both are null. Is there a way to have 1 with data and 1 null. -- So I can see all the customers with activity on 11th March...

I have an app which records farm livestock. When the user is entering a calf I want to offer the next available ear tag number. The ear tag number has the following format. UK 107248 4 00222. UK - County. 107248 - farm. 4 - check digit. 00222 consequetive animal number My prob is with...

I have an app which is going to different single users. Each user`s operation is slightly different. Some may have Gallop, Cross country. Others may have Arena, Farm ride and Gallop. etc In the test version the resources are listed in the query properties of a crosstab query. Is there a way to...

I have an app used by a number of single users. For printing invoices and statements some users like to use their own headed paper while others are happy with the header generated from the user detail table. I have 2 versions of each report, with or without header. I would like to store the...

Just had a call from a customer describing an odd problem. He has Office XP home edition & O97 I have an app running virtually prob free on over 20 machines (single users) A single form has a continuous sub form. When the single form opens the focus goes to the first control. Page up / down is...

I have a text box on a form header into which a date is entered to filter the data in the continuous form. A requery in after update does the trick. If I populate the text box from a calender form then the after update does not work. I can fire the requery from the calender form but I am calling...

I am trying to create a "diary page" so that all bookings can be viewed on one screen. I want resources along the top, eg Arena. Gallop. Farm Ride. Down the side times . eg 3.00 4.00 etc. I have been trying with a crosstab query which nearly works !! Problem is what goes in value. If I...

I have an app which handles data relating to cattle. The ear tag number consists of 3 parts. Country code - UK. Farm Code - 107248. and animal number - 600555. At present the complete set has to be entered for each animal. I am going to store the first 2 parts. then when the user tabs into...

In a reservations app I have a sub form (in datasheet view) that displays dates in desc order. As these dates are both in the past and present I would like current dates to appear when the form opens. ie. scroll up for future and down for past. Slight problem is that today may not be in the...

I am creating invoices for an app I am busy with. The transactions for the invoice come from 2 tables which store Sales and Facilities Hire. The current arrangement is that I create a temp table using append queries to get transactions from the 2 tables between selected dates. then draw these...

Not Nz ? I have a report with 2 sub reports on it. I am grabbing 2 totals from the sub reports for the main report footer. If there is data in each sub report no problem. However if one contains nothing I get error. I have been trying to use Nz to force a zero without success. This is what...

I am developing a bookings app which is similar to the resource scheduling example that comes with access. Each days timeslots are generated and the first start time can be specified. In the table that time slots are stored the first start time is as specified. However on the form that...

I download a text file and save it on the desktop. My app imports the data from the text file and compares it with data already stored and advises of discrepancys. Is it possible to get the date created from the text file so that the user can see when the last download was ? David b

I have a form with 2 listboxes side by side. By double clicking a record in the first lb that record appears in the 2nd lb by way of a table. The record id field in the table is set to no duplicates to prevent the same record being sent twice. If a duplicate is selected the access error box...

Ghudson posted a link to this code which created a copy of a b_e and zipped it . This works fine if the destination is C:\. I can not get it to send to A:\ Any thoughts on what it needs. http://www.access-programmers.co.uk/forums/showthread.php?s=&threadid=56751

The code below generates timeslots. it works fine apart from ignoring the start time. That is it always generates the 1st time as 1am not the time the user has entered on the form. Any thoughts on what is wrong ? Tia David b Private Sub OK_Click() On Error GoTo OK_Click_Error Dim...

Went to set a new customer off with an app on a machine running O97. Running Access error messages - SDM Error and Alert: FRetry SDM Error - were coming up. The customer said he had previously had problems saving Word files. A search came up with the probable cause as being Nimda virus...