Search results

Hi I have a form which has a subform. The sub form shows all other items in a batch related to the record being displayed on the main form as a continous form. What I want to do is that if a field IsNull, for the appropriate record on the subform to display red and if the field has a value for...

Just to be sure Bob Just to be sure I ran the program again after deleting the tables from FE and BE and the table definetly only appears in the FE Thanks Richard

Auto Update Bob Thanks for the program I have a problem, in your instructions for using Auto-update automation point 3 you say the table labeled 'tbl-version_master_location' is not in the be it is in the fe master, please advise if this is correct I have checked and I do believe that I...

Hi I have been looking for a way to update front ends automatically and came upon the code below. I have changed it for my file names, however when the front end needs to update I get an error message saying it cant find the control Me.TimerInterval I have tried replacing Me with...

Thanks exactly my problem

Hi I have created a quoting and invoicing database Four tables which work on a one to many relationship with the linking field the enquirynumber tblEnquiry includes details of enquiry, ie address, client, enquiryNo, make and model of car etc tblLabourEnquiry includes labour types, costs...

Thanks both for your answers The funny or amusing thing is that I moved away from Autonumber to put in the Dmax code!!!!!!!!, albeit the autonumber was for the actual field and would have created more of the problem I am having. With regards to the function from Dennisk. What would I put in my...

Hi I have a form which has upto three users entering at the same time using Front Ends on their desktops linked to a back end on a server. I have a field on the form which is updated using a Dmax piece of code. The number is unique. I am having a problem with the users being given the same...

the clincher was the ,vbdirectory after strFolder thanks Richard

Right the strFolder code works now, I also has some spaces in the "-" bit of the code which wasn't helping. However I still have the basic problem in that I don't think the code is actually checking the directory exists. Could you confirm or deny this and if not what function should I be using...

Still struggling!!! Have altered code as follows strFolder = " & strEnq & " - " & strJob & " - " & strSubJob" retvalue = Dir("\\nwaps-sbs\e\SurveyorsPhotosDrawings\strFolder") If retvalue = strFolder Then MsgBox "Exists" Else MsgBox "help" End If I am now getting a type mismatch error on the...

Hi I have some code that creates a directory on a server based upon fields from a form. These fields are represented in the code by strEnq, strJob, strSubJob. I also wish to check that the directory exists before performing the mkdirectory code. I have searched forums and looked at the vba help...

Hi I have imported data from Outlook. The field I am interested in is the 'Subject' Field. This contains 3 effective segments, 1 employee name 2 description 3 job and sub job number example of text in field is M.Heywood Completed Job No.1708 8 N.Curry Completed Job No.1477 I wish to move the...

Hi I have a table with three key fields table name is tblSampleDetails Field names are ClientSampleRef BatchNumber Visual A Batch may have many samples of which some may be visuals Currently I store a variety of values (some number, some text and some a combination of both) in...

Thanks for that, I need some help with the form for selecting the record to add the completed date. I was using a combo box for the Job number and another combo box for the SubjobNumber (using criteria to limit the second boxes selection)to select the right record but I end up overwriting data...

Hi I have three tables 1 tblAssistFMWork in which is stored the fields JobNumber, SiteRefNumber, SurveyorNo 2 tbltable1 which has the field SiteRefNumber, Address1, Address2 etc 3 tblAssistFMSubJobNumbers which has the fields JobNumber, SubJobNumber. JobNumber is the relationship between...

I was trying to be too clever and too complicated Thanks for the help

Am unsure of what you mean. Have changed to code as follows Forms!frmmtclientpricingenter![Combo9].DefaultValue =Forms!frmassistcliententry![Client Name] Now the combo box is showing #Name Please could you give a bit more detail, newish to access Thanks Richard

Hi I have a combo box on my form (frmclientpricingenter) which pulls up a record and displays the record on form. I want to enter a value into the combobox, using code, from another form and then the combobox pulls up the appropriate record. I am able to populate the combobox but it wont pull...

I have tried the change to a public function however I am now getting the error message 'Type Mismatch' when I click the command button 'cmdnewassistclient' Any Thoughts