Search results for query: *

Here I am again Lameid with my "report" I followed your instructions :- Ran Office 2010 Repair, still the same error. Uninstalled and reinstalled Office 2010, still the same error. Oh Dear I was confused now but had another think. The Office 2010 CD included Service Pack 1 !!! I installed...

Thanks again Lameid I am back home this week end so can actually visit the working database if things go wrong with the re-install or repair install. I did have the same thoughts as you about my original method so I think I will copy the CD mounted in my old Laptop (with a DVD Drive) direct to...

Thanks Lameid I am away from home at the moment with my new laptop. The database is in use back home at our club headquarters. I have access to it via TeamViewer but I dont want to do anything dramatic until back home next week. I am a little concerned about reinstalling Office as I used up the...

This query works fine with Access 2007 and on 2 other PCs running Access 2010 but not on mine since a bought a new laptop and loaded 2010. In real time I run the Query from my VBA Code but get the same error if I just try to run the Query direct. This is the error I get :- Undefined function...

I have an access accdb database created in Access2007. It is loaded on another Access2007 PC in the office where it is shared by 2 other PCs using Access2010. It has been running fine for years with around 11,000 records. Lately we have encountered a bug which has happened on two occasions weeks...

Hi SkipVought Sorry for the delay with thanks, I thought I would get an email but didn't. Also Sorry for the @ characters. I use them in my code to highlight "test" areas where I edit a bit of code to open a report to Screen for testing instead of printing and wasting paper. Your comments show...

I am having problems with Access 2007 which opens a Word Document then does a Mailmerge. The following code works fine to the default printer (which I want to use) BUT !!!!!!!!!!!!!!!!!! I want to set the printer to duplex and use Tray 2 (which is the main bulk paper tray) The tray selection is...

I am now trying something different, MajP replied to my original question with a comment about the way I have built my database. I agree but couldn't use his advise for my problem. I think my database is quite good, 9000 Main records, but I do struggle to get some bits to work. I am good at...

Hi MajP Thanks for your reply. I assume that Normalized is the same as Relational. This database is for the Marshals of the TT Races here on the Isle of Man. I am a self taught amateur who designed the Office Database. I share and link information (data) with a friend who looks after the website...

I have a MainForm with a RecordSource of Current_Marshal. In that there is a SubForm with a RecordSource of WWtable They are linked with Ref_No. On the SubForm there are 5 Controls, 3 come direct from the WWtable and fill fine of course, these are 2 comboBoxes and a TextBox.The other 2 are...

Hi Blorf (ChaZ) Thanks for the quick reply, I think you have answered the problem. My REAL problem is that this database sits on a website which I don't control. The pal that writes that side of the job lets me access the table via an address so I don't have any control on the output. I found...

I just went back into the Tek-Tips site and found that I failed to attach the database but noticed something which may be relavent ?? I created an empty Database then exported my table to it so that I could attept to attach the small database. When I now compare my original table and the small...

Thanks for the two replies. To Blorf The only number fields are Field1 and Field4 but they are just numbers. To SkipVought 20 Normal Open Pending Count = 1 30/05/2013 13:38 23328 IOMTTMA-D 20 Normal Open Pending Count = 1 30/05/2013 13:49 23328 IOMTTMA-D 20 Quit Button Used to Close 30/05/2013...

I have an Access Table called LogTable which is updated from various events within the Database. It is quite a simple table with 5 fields, Number, Text, Date/Time, Number then Text. I can export the table to Excel ok but sometimes the output stops at a particular record (call it Record x) which...

I want to run various filters on an Access Form then click a Command Button to send an email to all the Filtered Records. The email needs an attachment which is a mail merge document. The fields in the document come from the Form (or its underlying table) that you are viewing. I have used a...

I set up an Activity Table (TestTable) which logs various details as I open/close the database by calling the Function below. This worked ok until I wanted to copy the database to a laptop for remote use and then back to the office PC with this added to the Activity Table. I read that you cannot...

I set up an Activity Table (TestTable) which logs various details as I open/close the database by calling the Function below. This worked ok until I wanted to copy the database to a laptop for remote use and then back to the office PC with this added to the Activity Table. I read that you cannot...

I have DPNSS Route between a Mitel SX2000 and a Nortel CS1000. The SX2000 is connected to the Public Exchange. A call comes in from the SX2000 to the CS1000 and I can see the CLI (say my mobile number for a test call). If I transfer the call to another CS1000 phone the CLI is there. If I...