Search results

I need to check the content of a cell against the following and if it matches any of them them change the cell colour. I want to build if cell = "In('£0 0#','< MANDATORY >','<Mandatory>','Missing','tbc','tba','n/a','missing')" then colour it. The code does not seem to recognise < MANDATORY...

Dear all, I need to check the content of a cell against the following and if it matches any of them them change the cell colour. I want to build if cell = "In('£0 0#','< MANDATORY >','<Mandatory>','Missing','tbc','tba','n/a','missing')" then colour it. The code does not seem to recognise <...

Dear all, I have a variable called strCriteria and I use a select case to check a project status then check many variables, problem is my code picks up some of the strCriteria and sometimes does not? Is it the In function that is wrong? strCriteria = "In('£0 0#','< MANDATORY...

Link the spreadsheet to the db and use it as a table. Or stick example up here for us to view!

Stick the db on here so we can look at it!

Rotate the images using something like PaintShop Pro and then store the images.

Not looked at the TransferSpreadsheet method but you could tag a delete query onto the import routine where you delete all rows with no data?

(Q) How do I retrieve the UserName with which the user is logged into the network? (A) Paste the following code in a new module and call the function fOSUserName. '******************** Code Start ************************** ' This code was originally written by Dev Ashish. ' It is not to be...

Dear all, I have converted an A97 db to A2000 and when I tab out of some fields the db crashes. Are there any known errors or problems that you can point me to?

Check out http://www.mvps.org/visio/ you may find some help!

FormatCurrency(Expression[,NumDigitsAfterDecimal [,IncludeLeadingDigit [,UseParensForNegativeNumbers [,GroupDigits]]]])

Dear all, I have once again had to post this request as I am still struggling. I have attached a zip file with two screen shots: Access1.bmp is the Report Print Access2.bmp is the Report Design My problem is this: I have a report with 6 subreports placed in the detail section as close to...

Thanks I probably waffled on. When I load a form how do I ensure that a textbox always shows the boundcolum(1) value even if the listbox shows nothing?

I use a text box to enter a projectID and then a Select SQL to populate the rowsource of a list box, which can be clicked to open related form. I want to place one of the column values in a textbox on the search form but I am unsure which event to use? I used AfterUpdate but it does not...

Rich is right, you have the same button name several times.

How are you controlling access to what based on the User Level? I am curious to learn this?

1) Create an unbound form, call it frmMenu and put the command buttons on this form. 2) Create a Macro and add the following actions OpenForm and select the FormName frmMenu. Save the Macro as AutoExec 3) Close the database and then open it again.

not a mega expert in this area but could one problem be: For Each x In .Range("A4:A" & iEndRow) For Each x In .Range("A4:A" , iEndRow)

u left out the customer table also

zip it up and post it to this forum as the more who view it the better answer you get!