Search results for query: *

Hi I need to display selected entries on a form and also a report. The selection is in a variable called gstrTester. The call to the form is: DoCmd.OpenForm FormName:="frmSelected", WhereCondition:=gstrTester. The contents of gstrTester appear in the form's Property Sheet Filter box and the form...

PHV kindly sorted my problem of changing a subform from a function with: Forms![frmRenewalList]![subfrmTotals].Form!PCCount = PCCountHold I would now like to do the same thing with a subreport. I've tried variations of the above with no success. Can anyone help me, please?

I have 'inherited' a database. In it is a query which looks like a simple Select query but when it is run it produces a table with a bottom line of Totals with the sum of the numbers at the foot of the numeric fields. I would like to do something similar in a database I am working on but I...

I can make changes to a form from a Function using the following code: "Forms![frmSomeName].btnFirst.enabled etc". I would like to do the same to a subform but the code "Forms![subfrmSomeName].btnFirst.enabled etc" does not work. Can someone help me with this, please.

After having a flood of returned e-mails, none of which I sent, I now find that, although I can send e-mails I can't receive any. Clicking on send/receive shows something is processing - presumably locked. It also shows a 0x800CCC0F error. Any suggestions, please.

With Access 97 on a network server several users could access a database at the same time. Now, with Access 2010, this facility is no longer present. Is there any way of restoring it, please?

I have written an Access database in 2010 to be run on a 2003 system. The database (.accdb)ran with no problems on my machine. I converted it to 2003 (.db) and it ran with no problems on my machine. However, on installing it on the machine it was intended for (2003) although it ran with no...

Despite the table being in the correct order DoCmd.GoToRecord , , acFirst does not display the first record. Can anyone tell me how to make the command work correctly, please? I'm using Access 2010.

Hi. I have a single main form but now would like to show two pages with the controls now appearing on the main form appearing on page one and other stuff on page 2. I created two pages, cut the main form and pasted to page one but the stuff also appears on page two which I don't want to happen -...

I have a form which contains an unbound control called "software". On opening the form, control "software" is loaded with the contents of Public string "SelectedSoftware" in "On Activate" with no problems. I want to do the same with a Report but cannot load "software" with the contents of the...

I'm trying to create a make-table query using True and False in the fields. Simply using True and False doesn't seem to be the answer. Using =True and =False only results in the = disappearing. Can anyone help me, please.

My Vista Security Center is turned off and defies all attempts to turn it on. Can anyone help me, please?

Hi Having had my previous query on inserting data into a given field of a table successfully answered, I would now like to be able to do the reverse, ie read the contents of a given field in a given row. As an example: find the contents of field 'Printer type' in row 4 of table 'tblPrinters'. As...

Hi I want to reset the contents of all instances of a field in a table. I have in mind (all necessary dims taken care of): Set db=CurrentDB Set rst=db.OpenRecordset("tblPrinters") For i=1 to rst.RecordCount [insert fixed text into required field] Next i How do I address the required field to...

This is an Access 2003 problem. I have a table - Table1 - with a field 'Date' containing dates in medium date format. I want to be able to create a second table from Table1 containing only those records matching a year only entered in a separate form. Is this possible? I would appreciate any...

I have a delete query which has a field "Date Purchased". On my form frmDeleteByDate I have a box "Date" formatted as Medium Date. In the query in the "Date Purchased" column I have <[forms]![frmDeleteByDate]![Date] the object being to delete all records with a date less than the date entered...

Having had to replace my had drive, I managed to copy outlook.pst from the old drive to the new. Clicking 'Contacts' displays all the data but clicking the 'To' button when sending a new e-mail tells me that the file has been moved or does not exist. How can I rectify this, please?

I want to be able to clear all fields in a record displayed in a form, ready for insertion of new data. Deleting the record is not possible as the record is linked to a record in another table and I wish to retain the link. I know I can do it by deleting each individual field but as there are...

Hi I'm hoping to be able to open, edit and print a Word document from an Access form. I believe this is possible but can find no instructions for doing it. I'm running Access 2003. Any help would be much appreciated. Regards John

I wish to import data from an Excel spreadsheet into an Access table. I found a command in a help file somewhere but can't remember where and unfortuately, did not make a note of it. It started: "DoCmdTransferSpreadsheet acImport," or something similar. Can anyone, please, complete it for me or...