Search results for query: *

Hi I have no experience at macros in Excel. I would imagine i need to use the lookup function, but no idea in creating a macro and then formatting the colours! Col C - holds Invoice Date Created Col D - I would like to be the number of days since Inv created. When I run the macro, i would like...

Hi I have a check box, that when clicked it inserts "t/s " at the beginning of a text box keeping other comments that may be in already... When I uncheck the box, I dont want the text box to be null, I want it to remove just the specific part, "t/s " Is this possibe? and how? Private Sub...

Hi I have a query and am using the below Dim StrFileName, StrFile StrFileName = "TEST100" StrFile = "\\Lynxserver\lynx\Payroll\NewEmployeesSAGE\" & StrFileName & ".csv" DoCmd.TransferText acExportDelim, , "SAGE UnionTEST", StrFile, False The csv file always has the same name How do I get the...

Hi I have sort of asked this question before and was just wondering if it is possible at all??? I'm trying to get the data into a Sage Payroll CSV file, one of the problems is that the field name is: Contact Telephone No. in the query below, part of the code is: Null AS [Contact Telephone...

Hi I have an InputBox and am trying to validate it... How do I force the user to ONLY type in numbers I.E. like an input mask? ##/##/## InpValue = InputBox(InpMsg, InpTitle) Dim InpTitle, InpMsg, InpDefault, InpDt Dim InpValue As Date InpMsg = "PLEASE ENTER INVOICE DATE - E.g. 23/05/07"...

Hi, I have this code to create a csv file Private Sub cmdTestCSV_Click() Dim StrFile StrFile = "\\Lynxserver\lynx\test" & ".csv" DoCmd.TransferText acExportDelim, , "SAGE EmployeeDetailsTemplate", StrFile, False End Sub Below is the query in Access... The field in BOLD/RED is a bank sort...

Hi I have a query, in the one field, I have the below statement, however i need to make it more complex, like an if...else statement Desc: [EmpForename] & " " & [EmpSurname] & " - " & "Basic Rate" I would like it to show: ON ALL RECORDS Desc: [EmpForename] & " " & [EmpSurname] & " - " &...

Hi I have seen similar posts BUT hopefully some1 will be able to get me there easier and quicker. I have a form (continuous), I can either use a box or preferably use the BackColour of the details (If Possible) On the form i will display more detail, However what i'm trying to achieve is...

Hi How easy would it be to populate a combo box with time values using something like me.combo.RowSource = "Select ........." Or whichever method is easier and do you have some code? e.g. 00:00 00:15 00:30 00:45 etc etc Thx, appreciate it Darin

Hi I have the simple code below to calculate the time difference. How would I change or format the final result 1:30 TO a number 1.50 Private Sub cmdTdif_Click() Me.Tdif = HoursAndMinutes(Me.Tout - Me.Tin) End Sub Thx Darin

Hi I'm using access 2003. I'm trying to do an update (tblPayInv) query taking information from a table (Table1INVnumbers) SETTING tblPayInv.InvNo = [Table1INVnumbers]![invNO] The 2 criterias are (tblPayInv)WEdate must be IN Table1INVnumbers(wedate) AND (tblPayInv)InvNo must be IN...

Hi We have a rota, the page breaks have been set and I would like to have the top row which contains the Day & date, to be printed at the top of each page, preferably in the Header area... Is this posible? how would i go about this? Thx Darin

Hi I have this code in the current event of the form.. However, I tried adapting it to a MODULE (Photo) and inside the module, me. could not be used so i changed it to MyForm.. Below is the code BUT the image is not appearing... Please can u help!!! Option Compare Database Option Explicit...

Hi I am already using this code to create a new record. This works fine BUT if 2 people try create a record at the same time, an error occurs as the EmpRegNo is the same... Private Sub cmdNewRec_Click() Dim VarEmpReg As Integer VarEmpReg = Nz(DMax("[EmpRegNo]", "tblEmployee")) + 1...

Hi I have these 2 strings of code below When i'm working on the design at home, I use the 1st line and when at work the 2nd... 'stPathA = "C:\Lynx\EmpPhotos\" & Me.EmpRegNo & ".jpg" stPathA = "\\Lynxserver\lynx\EmpPhotos\" & Me.EmpRegNo & ".jpg" Is there an easish way to change this in an...

When a person makes changes to an employees record, is there a way of getting ONLY the changed fields and placing them into a memo field When Saving the record ? Lets call the memo field (empChanges) I would concatenate them, not sure if the label caption would be included. Would be preferable...

Hi I'm using this code in the form current event. it seems to be working ok BUT it took a bit of playing around etc.. Has it been written correctly and most effectively, that is, is it best in form current? AND the error handling part? Private Sub Form_Current() On Error GoTo...

I'm trying to find a simple solution to an employees form / table. the form is set to edited record, and record - locking in progress. A user has to sign into the database. I was thinking of Creating a field in the table, LockedBy = text Then hide a txtbox on the Employee form... As soon as...

Hi ---Reason behind this is to open a different DB and Update the original 1 using filecopy--- I used this code last night, it seemed to work fine, However, today at work its not doing anything? Dim appAccess As New Access.Application appAccess.OpenCurrentDatabase ("C:\Lynx\Test1.mde")...

Hi I have some simple code 'FileCopy' which i would like to use when closing the database. I'm not sure where to put it AND whether it would work as you cant copy a file if this is already open. My users are using an MDE database on a server. I'm continuously updating the file therefore, when a...