Search results for query: *

The problem has been solved. Please see http://tek-tips.com/viewthread.cfm?qid=1709967 for solution.

The PC was reimaged and said problem has not occured since.

How about creating a macro that sorts the data on the column in question?

Hi, Thanks for the reply. Sorry, I don't know anything about roaming profiles. The situation is that the IT department setup/maintain the system and although I am not technically IT, the fact I have more knowledge than most I have become a bit of a de facto IT person, which is why I am looking...

Hi, Where I work we have a number of people who do not have their own PC. Instead they just grab which ever PC happens to be free in the office at the time. The problem is that Outlook has to be configured per person per PC and this can be a tiresome task for me to do. When you first open...

Hi, Where I work we have a number of people who do not have their own PC. Instead they just grab which ever PC happens to be free in the office at the time. The problem is that Outlook has to be configured per person per PC and this can be a tiresome task for me to do. When you first open...

It doesn't seem to be the MSXML version either as I have tried versions 3 and 6 too. What happens at line 310 is the string variable strName is updated with the value from .ChildNodes(enmUserXMLName).Text. Any attempts to then use this variable produce run time error 5. For example, 400 If...

That's the problem - there are no references marked as missing. Many time I have created a new database, imported all objects (on some occasions, used the SaveAsText / LoadAsText for VBA modules in case one of them is corrupt) and added all the references again. When I run compile, no errors are...

After some trial on error on several PCs, I suspect my version of Office (2010) is corrupting the VBA when I compile the code. Once compiled, any string variables throw run time error 5. I tried importing all objects into a new database on a different PC and no problems. Thanks for your help.

Dear all, I have been advised that my post http://www.tek-tips.com/viewthread.cfm?qid=1709889 may get a better response if posted here. Apologies for double-posting.

Dear all, Recently I have re-written some VBA code in a split Access database to make it more efficient and eliminate some redundant functions/subs. Basically, an XML file is opened through VBA and certain data from it is transferred to variables created within the frontend database. The...

Hi adwyer, Why not link the external table into you local database and create an append query to copy all external records into the local table? You could just copy the Primary key field. You can then run the append query before you start any work on your local database. For this to work, the...

Hi Carkick, Shouldn't there be three tables? One for jobs, one for materials and one to link the two together? The Materials table would contain all info on each unique type of material, the Job table would contain all info on each uniquie job and the third table would be a junction table...

Hi grchang, I think you might get the results from a query. Create a new query and select the table where your data is held. Select fields Contract then in manually create the following calculated field: PriceA: Iif([Tier] = -1, 0, [Price]) If the Tier is -1 then the Iif returns 0...

Hi Dyer01, What is the macro command you are using? In the past I've made the mistake of saving the form (which does not save the record).

Hi boardgamer, 3304: You must enter a personal identifier (PID) consisting of at least 4 and no more than 20 characters and digits. Is this the message you are getting? Sounds like could be a missing workgroup file (.mdw). You can set the workgroup file by going into Tools then Options...

Can you post the code that does this?

Carkick, I don't think this can be done as a datasheet because if you requery a combo, all records having some other value than the previous combo will seem to disappear. You could probably do this on a single form which only displays one record at a time and requery all combos everytime you...

Hi LouieGrandie, You could simplify using a WITH statement: With Me !SelectionsOwner.Enabled = !SelectionsYesNo !SelectionsEstimatedTime.Enabled = !SelectionsYesNo !SelectionsEDC.Enabled = !SelectionsYesNo !SelectionsCompletedDate.Enabled = !SelectionsYesNo...

Dear all, As part of Access (2003) VBA (Win XP), I am aware it is good practice to close any objects to explicitly open in any sub/function so that these objects don’t end up “floating around” in memory. The current way I do this is: ============================================== Public Sub...