Search results

Hi Lagpot, yes I did change the names of the AnyFormTextbox and fcalendar to the names I have given. The error occurs at the following line on the calendar form when I'm trying to assign the date value from the calendar to the control: TargetControl = Me.Calendar.Value Thanks C

Thanks lagbolt. Your method makes sense, however when I implement it there is nothing being passed to the TargetControl variable on the calendar, therefore an error message appears advising me "Object variable or With block variable not set".

I have a sub form (SubForm1) embedded in a Tab Control on Form1. Subform1 includes a text box called Date1. When the user clicks in Date1 a Calendar form opens. When the user selects the date on the Calendar the date should be populated in Date1. Instead of that happening the following error...

There is no need to change any settings, whilst you are in design mode select the print preview button. Whilst in print preview save the chart and then close it. When you re-open it in design view the chart will show actual data and not default. There is no need to change any settings. I hope...

All sorted!! View the chart in Print Preview and then save and close it. If you re-open it in design view the actual data is displayed.

I have created a report that consists of a line chart When I view the chart in design view (including the datasheet) the data that feeds the chart is not displayed. Instead some default data on East, West and North is displayed. I need to see the actual data in design view as I need to format...

I have a table of data which contains daily sales achieved by employees I am trying to put together a query that sums each employees sales into weekly totals: Week1 Week2 Week3 etc. John 12 7 8 etc. Paul 6 12...

So could you tell me the syntax for a query output to directly update a table please.

The purpose of the table is to generate a chart. I have 4 queries returning information for a line chart, putting the information into a table has been the easiest way of producing the chart.

I have two tables, A and B I currently run an update query which updates table B with data from table A. Table A is constructed using a make table query. The question I have is would it be possible to update a table directly using the output from a query? If so a point in the right direction...

Thank you, I cannee believe it was so simple!:o

I have two tables, table 1 contains 3000 staff records and table 2 contains 300 staff id's. I need to configure my query so that when it runs the staff records are returned not including the 300 staff id's in table 2. I thought this would be as straight forward as pointing the criteria to the...

I have a table containing names and addresses. I need to replace the house numbers of the addresses with asterisks- 35 John Road 891 Gray Street Update to * John Road * Gray Street How would I achieve this using an update query?

I have a table containing names and addresses. I need to replace the house numbers of the addresses with asterisks- 35 John Road 891 Gray Street Update to * John Road * Gray Street How would I achieve this?

I used the append query to create table in destination database! doh!! Thanks GC

I have an odbc linked table in database one. Using the transferdatabase method I want to copy the table into database two as an embedded table (not linked). I have tried to do this but an odbc linked table appears in database two. Database two will be sent to users who are not based on the...

Each db is different as the data it contains is specific to each user.

I have over 30 databases that must be sent to external users on a daily basis. The databases must be sent as MDE files. The current process is to manually convert them. Is it possible to automate this task using VBA? A point in the right direction would be appreciated. Regards C

I must create databases from a template for approx 20 different departments who do not have access to the shared network. Some of the data is specific to each dept (and highly confidential) so we will create individual stand a lone db's for them. One final question, can I convert a mdb to an...

I have a database called Control.mdb. A form within control.mdb opens a database called Template.mdb using the following code. Dim appAccess As Access.Application Dim dbPath As String dbPath = "C:\My Documents\Template.mdb" Set appAccess =...