Search results

Hi all does anyone know how to use a tempvar in the following line Forms!ColdTemperatures![TempVars("Button1")].ForeColor = vbRed what im doing is on close of a form I want to change the colour of a button on another open form (the name of the button is held in the tempvar) But i cant...

Hi all I have been working on a bound form (For ages!) that I can't seem to getting working It records deliveries and what I am trying to achieve is after the form has been filled in the user will click a save button where the record will be added to the table and a record automatically...

Hi Everyone I was looking for some help I have a form with 15 unbound text boxes (daily temperatures) and what I am trying to do after entering the temperatures into the text boxes the user clicks an add button which will add 15 new records into the temperature table the code I have...

Hi All Its been ages since I've been on here so hello to everyone again :) Im having some probs getting an update query using vba to work have tried doing loads of things but cant seem to get it to work, Im sure its something small and stupid Im doing! what I have at the minute is below and...

Hi all I'm working on a bit of code that before a combobox is changed checks with the user to confirm that they want the change to go ahead, if yes a recorded is added to a table this all work fine apart from if no is selected - I am trying to get the combobox to undo the change however...

Hi all Hoping someone can help me with this, I have a check box on a form that after update I want to insert details into a table CurrentDb.Execute "INSERT INTO Communication([CommunicationType],[Date],[JobID],[MethodReportedID], [Notes])VALUES ('22', Now(), " & JobID & ", '6', ' Comment...

Hi All I'm having a problem getting a bit of code to work :banghead: (see below) I have done if statements loads of times but I am having a real problem getting this to run without errors, I have changed it round and round different ways but can get it done. I need an if and else statement...

Hi all Its been a while since I have been on here in fact its been a while since i have been using access and as usual I am stuck on one thing that I have been working on for hours trying different things to get it to work so hope someone could give me some advice please bear in mind I'm still...

Hi all :) I'm not sure if this is the right forum to post on but here goes, I am exporting a query from access 2007 to excel 2007 and my yes / no columns are changing to true / false in excel is there any way to make these appear in excel as yes / no instead? regards Jackie :)

Hi all :) This is probably a really simple question but one which I cannot find the answer too, I have an data entry form in my db which allows me to enter in a new job ( job id, customers address, postcode etc) but as we do a lot of work in the same area a lot of the addresses are the same...

Hi all :) I have a form with 2 combo fields one which shows who a job is initally assigned to, called Initials and one which shows who actually carried out the job called Initals2 what I want it to do is to automatically copy the name in the initials field to the initials2 field but be able...

Hi all :) I found a great email example on the web written by blue claw database designs see code below and (I have also attched the file for others to use)what I am looking to do is to get it to send using the out going email address I specify, I have two email address running out of outlook...

Hi all :) I know there is a number of treads on this forum devoted to emailing reports etc as the main body of an email but they are all to in-depth and I can’t manage to simplify them to get them to work for me What I basically want to do is I have a report called: report_titan I have a...

Hi all:) I am looking for some advise, I work for a small service company and we our trying to computerize our service jobs through the use of access 2007, We have completed 80% of the database but are having a few problems completing, for example the search function on some forms etc, I have...

Hi all:) Has anyone ever come across an example of a form where you can carry out a multi criteria search which not only displays the results on a subform but when you select an item from that subform the details can be displayed in text boxes etc on the main form. I have tediously searched...

Hi all :) I am new to access and have been working on creating a database to manage service jobs. I have adapted the search code which was very kindly placed on this forum by Grommit but am having problems getting it to work. To some of you out there this is probably really simple to fix but...

Hi all :o I now finally managed, with the forums help, to successfully adapt and use (very slowly due to my lack of experience)some search code kindly placed on the forum by Gromit. What I am looking to do now is place the search in another one of my forms. I have access 2007 and the form a...

Hi all :o I am still having problems adapting the search code placed, very kindly on this forum by Gromit. When I run the search none of the results populate even when I know there is a match :( The code I am using is Private Sub Form_Load() ' Clear the search form...

Hi all:o I am new to excel and I was looking for some help, I have a spreadsheet with a list of Job Id and address etc (exported from access) and am now looking to arrange the spreadsheet, I need it to divide the rows into sets of 50 ideally all held on one page, with a numer of running...

Hi all :o I am working on a query but can manage to get it to do what I want. I have a main table with a job_ID and a faults table which documents faults that occur related to that Job_ID the tables are related with a one to many relationship. I want the query to bring up all the jobs even...