Search results

its a work generated pdf that i have converted to doc help please - anyone

I need help I have a 5000 page document and I need to run a macro so that it searches for a value (eg - "32 entries per line") and if that value is found then THAT page that the entry is found is deleted and so on until the end of the document. Can someone help me with the macro/vb code...

How can i set the iamge to TIGHT formatting - When recording the macro this option is greyed out any VBA coding to force this formatting? CODE USED If ActiveWindow.View.SplitSpecial <> wdPaneNone Then ActiveWindow.Panes(2).Close End If If ActiveWindow.ActivePane.View.Type =...

Is it possible to setup excel (VBA) to return a msgbox if certain text is entered into a cell - and if not then no msg is displayed? ie if cell value is "test" then msg box appears with msg if cell value is anything else then msg box does not appear If possible can this be done on a...

srry gemma just to say your nz code works

.value = false is supposed to read if field is blank or contains no value

Thankyou gemma your code works however on of the fields is a list box and contains numbers and letters (text) the list records are pulled from a table that contains the values how can i get the code to work for this as even if there is a entry or of field is blank i get the sorry: Not all...

Sorry Msg Box States object Required

now using below when button is click get msg box saying missing object Private Sub Command23_Click() On Error GoTo Err_Command23_Click If Cust_Name.Value = False Or User_ID.Value = False Or Account_Number.Value = False Then MsgBox "Missing information Please fill in ALL FIELDS" If...

sorry i dont understand (nz?) i have tried the below and it get error ELSE WITHOUT IF Private Sub Command23_Click() On Error GoTo Err_Command23_Click If Cust_Name.Value = False Or User_ID.Value = False Or User_ID.Value = False Then MsgBox "Missing information Please fill in ALL FIELDS"...

i have tried .Value = False then msgbox "missing data" no joy

Please can someone help I am trying to add code where by when i click the exit button, i want the function to check all fields in record to see if there is a value present if no value then msgbox needs to be displayed to show which field is missing data eg If User_ID = "" Then MsgBox "Please...

I have put the following in Private Sub Form_Issue_KFI(Cancel As Integer) Datepresent = Date End Sub the brackets after date auto delete when i put them in I have now set the control source right, however the value now shows as #name when i run the form

Thanks for that, that does work, however this is not saved when i exit the form, whereas everything else is (Datepresent field on table is blank)

the field is called Datepresent (Is in format Date in Table edit mode) the form is opened so that a record can be amended. I need this field to be filled in automatically with the present date once this is done when i save and close the record, i need the new date to save details in the table...

Please can someone help I am using switchboards, and i open the form in edit mode. Is there anyway to show the present Date in the text box. The task is to save the Date in the field (so that it shows in the relevant table) In other words once Todays date is showing in the form then when i...

Solved ITS OK I figured it out =COUNTIF(C9:C400,"3") this counts how many times 3 appears in a column =COUNTIF(C9:C400,"accept") this counts how many times the word "accept" appears in a column Thankyou

Hi all Just waning to know, if i have a set number of values and i want to know how many times they have appeared, how would i display this :eek: eg 3 3 5 23 5 6 I am wanting to know if how many times 3 has appeared, Answer is twice or 2 How would I go about doing this in the spreadsheet...

Import Export Hi Just an idea but Have you tried to create a new database and import the table, Once you have done this try deleting the record. Save the new database, then delete the table from your own DB and import the table from the new table. *** PLEASE BACKUP YOUR ORIGINAL DB FIRST...

Import Export Hi Just an idea but Have you tried to create a new database and import the table, Once you have done this try deleting the secord. Save the new database, then delete the table from your own DB and import the table from the new table. Worth a try Hope it helps