Search results

I'm a die-hard 2003 user. I recon 2007 and upwards too much attention is paid to the User and the Developer is forgotten...just my feeling. I charge more if I have to develop in 2007 or 2010 :) Nope - you'll find "Detect and repair" under the Help menu. It is almost like a re-install. Even in...

Don't worry I got it stored on my USB flash :) I just hope this exercise solves my initial typing bug...

Ok - I uninstalled and re-installed and then added SP3 and the following hotfix: office2003-kb945674-glb.exe This got me to 11.8204.8172 I read somewhere that 11.8321.8405 is the latest hotfix. Anyone got a link to the hotfix? Thanks again

It did it again this morning that is why I started this thread and I fixed it by doing a detect & repair. So in theory a total un-install and re-install might be the answer. The only reason why I did not do it as yet is that I can't remember which service packs and hot fixes are the best to do...

Nope - no event timers. It also happens on not just one of my databases. I had it happening on brand new projects I started from scratch.

Hi all, I'm not even sure what to call this bug but let me try explain. Sometimes when opening Access and entering some code in the VBA screen the system starts messing with my typing in a bad way. For example I would want to type the following: "me.mycombo.requery" The normal state of affairs...

Hi - thanks for the replies plog - you right - I do need to fix it from the query side but it is a complex qeury not designed by me so I need to figure out what is what first. spike - I do know all the field names and they are all bound to their source but depending on the outcome of the...

Hi all, Not sure how I'm going to explain this problem but I've got a form based on a crosstab query which result gives me a number of data fields which I then refer to in the form. Depending on the resulting data of the query some fields exist and others not. I have no way of knowing which will...

Ahh - Google is my friend. I had to end of the script with the following line:

Thanks I did try that but both lines look identical. The only diffrence I can pick up while doing the link manually is that it asks me for the "Select Unique Record Identifier" which is not spesified anywhere in the VBA code method. That made me look at the design view of the 2 tables and I...

Hi all, I'm using this code to link to a ODBC Pervasive db table: The resulting table is however read-only. However if I link to the table "manually" myself it results in a read/write table. Am I missing something in the above procedure? Thanks Pierre

Ahh thanks Paul you beat me to answering my own question.Google led me to the same link.OT1: DLookUp("Qty","ExOT1","[Staff] =" & [Staff] & " AND [TSNum] =" & [TSNum])Did the trick.It is 3am here - might be the problem... :)

Hi all, I need some help with the syntax in setting 2 criterias for a DLookup query. I've attached a sample db with 2 tables: Main & Timesheet I need a "combo" query showing (on the same line) all Qty for Transcodes N, 1 & 2 where the Staff number and TSNum is the same. I'm sure about...

Hi London, Thanks for the clarification yes - it is password protection I really need. PDF would suit me better than Excel since the format for the payslip is already half way there. I remebered that I had a piece of code that coverts a report to pdf and when I looked at the parameters I...

Hi all, Need some ideas. I'm sending payslips to Staff members of our Clients but they would like for it to have encryption on it. At the moment I'm sending it in Snapshot format. I can convert the Report to pdf as well and send that. But I don't know how to add encryption. I'm also thinking...

The way our databse works is like this: All users are on the frontend with the backend on their own local server. As soon as any of the users logout, the lastest dataset gets uploaded to the web. This then gives all remote users access to the latest dataset but only on a read-only basis. The...

I think it is quite normal for Access to take a while for you to see the table. Sometimes you have to click on another object say Queries and then back on Tables to refresh but I don't think it means the table does not exist yet. So refreshing the database window is a fine trick allowing you to...

Above is what I would have suggested yes. Where are you hosting the tables. On a backend server setup? Is the lag not coming from the server maybe

I'll be watching this thread but as far as I know you cannot work 'live' on an Access database backend stored on the web. You need to look at a variant of SQL for that.

Maybe start by posting the code you using to add the table