Search results

Thank you Galaxiom. I get the first bit, storing currency daily currency rates. I get the second part in that you can return the GBP value (Invoice value / rate) What currency would i store the data in the third bit? If i store as GBP £ i can only return total GBP values in queries/reports. If...

Changing the colour is easily achieved with conditional formatting. You would just need Field Value Is | less than or equal to | Date() You could build a formula to use as the control source for the textbox and return EXPIRED or the date as appropriate BUT you would not be able to do anything...

Hey guys, I am pulling together a database to control invoices and proformas and the payment of. These will come in different currencies and non GBP will be paid in that currency via a trading site (best rate!). I need to record the original value and the GBP after exchange. I have hit a snag...

hi nstratton Not sure but most times i see DIR used to check for existence of a file, developers use Len() of the return and check for 0. So If (Len(strFile)=0 Then Not sure if DIR() returns "" for no match or NULL.

Hi DaRTHY You need the DISTINCT keyword. So SELECT DISTINCT...... If the other fields are not important, take them out of the query.

Hi JL, USB bar code scanners do not need a DLL. The input from the scan is received as the numerical read of the code. True the Symbol LS 2208 can have other connections, but on a PC the USB is the more likely. Mostly you have a 'setup' card with various barcode's and after connecting the...

Could you capture the file path and post it - exactly as it displays?

Is Me.Link the full file path or just the document name?

Hi Santhosh I would assume your table would also include a field to identify who Activity, Start Time, Start Date, End Time, End Date , Resource Incharge, Machine .... refer to? So your form needs to include a control to record the employee, this could be a textbox or combobox for example. Now...

Just be careful arnelgp, that would return J: from tubar's example. You would need to find the second \. If you knew the path would always be relative you could do Left(TextBox1, InstrRev(4,TextBox1, "\")-1) EDIT: Ignore me... missed the reverse version of the function :banghead:

Hi El-d I suspect your problem lies in a couple of possible areas. First the function declaration does not specify what variable type to return. Change it to Function RunAvgQ(QueryName As String, KeyName As String, KeyValue, _ FieldNameToGet As String, RunLength As Integer) as...

Hi tubar Yes, just use the Left() function. If you know how many characters you want it would just be something like =Left(TextBox1,15). If the number of characters is dependent on the location of a certain character (eg the second \) you would need to first use the Instr() function to identify...

Hi Steve OK so yes you need an append query. Create a new query using qryCallsByDate as its record source. On the menu bar with the query editor open, you have a set of icons to indicate the query type (at this point it should say select). Click on the green + Append. THis will produce a box...

Hi Steve Your post is a little hard to understand, but if i understand correctly, you want to take information on a form and write it to other records to save time? If so you need an Append query. But to help further I think we would need some idea of the relevant tables and queries.

Hi Cowboy The function you are looking for is DoCmd.TransferSpreadsheet. One of the parameters will allow you to specify where to put the data EG DoCmd.TransferSpreadsheet acExport, 8, "qryFinancialData", pathToSpreadsheet, True, "Tab!RANGE" where Tab is the tab name and RANGE the range/cell to...

You may already do part of this, but this is how i handle logo's and other graphics that the user can/may change. I have a parameters table and one of the entries will be for the logo file path. In the Current event of any form/report that requires the logo i call a function to return the file...

Hello Paul, It would be great to get a few of us around a table again. I will find it a little difficult in the foreseeable future as I have just started a new job as a Supply Chain Manager and am bouncing around all over the place. Latvia and Estonia are possibly on the cards. Hope you are...

Hi Siggenis Word merge? I take it you mean Mail Merge in Word? If so it is doable if the images are links to the image and not the image itself (although there are ways to do this also but very different). Have a look at this article for guidance. https://support.microsoft.com/en-us/kb/909132...

you can use the Printer object to set most print parameters. Have a look at this link. https://msdn.microsoft.com/en-us/library/office/aa223133(v=office.11).aspx

Do you mean from the point of view of selecting a printer or knowing something is happening? With the former you could have some code run first asking the user to select printer (or set a specific printer if the same printer is always used), with the later I would suggest displaying a modal form...