Search results

Good afternoon folks, I'm looking for some assistance on how to write some code that will search a known drive and folder structure for a tif file and on finding it, open that tif file. The known drive/folder structure is as follows: M:\CustomerSatisfaction\StdDGImages or it could have...

Hi, Thoughts off the top of my head are that you need possible 4 tables as follows: Table 1 [People - Names (Forename, Surname etc)] Table 2 [People Relationships - Grand Father, Grand Mother, Mother, Father, Brother, Sister, Husband, Wife etc) Table 3 [Medical Conditions] Table 4 Link...

Hi, I'm assuming that you are talking about a user being in a specific form view. You can use the following to get the User: Dim sUser As String 'Declare the sUser as String sUser = Environ("UserName") 'Get the Logged on Users name I use the above code to identify which user is...

Hi, I'm assuming that you have a table that contains your sequence number. I've attached my example db which is Access 2000 version. I've created an example table with an autoID field and a text data field in it, and a basic query. If you open the query up in design view you will see how I...

Hi, Sounds like the issue is with the printer and not Access. Access can only tell the printer what colour it wants, if the printer doesn't translate the data correctly then what your experiencing happens. Regards John

Hi, This is something common from my experience, you have to adjust the report Page Setup to fit all your data onto one page, if you have already set your report to the maximum, then I would suggest you re-adjust all the properties within your report until you get the report on one page as...

Hi, In the report properties use the conditional formating option. Select the text box object that is associated with the field in question and the click on Format/Conditional Formating and then where you see Condition 1 use the options there to change the font colour to white if the value...

Hi, Glad to hear you have it working as desired, I'm happy to have been of some assistance. John

Hi, It appears to me that you are missing the "Me!" part of the code that refers to the objects on your form, the reason I believe this is because you have the ".value" after [DebtCollected(£)] and [DebtGenerated(£)]. which normally suggests that you have objects on your form name as such...

Hi Boblarson, Thanks very much for your post, that was just the ticket I needed. Most appreciated. Hi Gemma, As my file extension in this case will always be ".tif" the solution Bob and pre-eugin, was what I was looking for, but I will bear your observation in mind if I need to deploy a...

Hi pr2-Eugin, That looks like what I need, how do I call that function from within my query grid? regards John

Hi pr2-eugin, Thanks for you help there, it successfully removes the ".tif" which is what I wanted to remove the leading characters \\domgennt.dggroup.com\global\Resource\Applications\UNI\eFlow\IMAGES\ leaving me with the following: 00056273_ELECTRICALRETAILER_001_3...

Good day folks, I'm having a problem working out how to create an expression that removes the ".tif" extension of a file path. The data looks like this in it raw form: J:\20130308\00056273_ELECTRICALRETAILER_001\00056273_ELECTRICALRETAILER_001_3.tif In my query grid in the filed row I...

Hi, Create a process within Excel to do what you want, have a master spreadsheet with the code in it and action it from there. Excel has some powerful features of it's own, if you explore them you will be supprised at what you can achive. Regards John

Hi again, To copy a worksheet from workbook to another retaining the same tab name do the following: Open up both workbooks, select the worksheet tab from the workbook you want to copy from and Right click the tab and select the option "Copy or Move...". The Move or Copy dialog box will pop...

Hi, Why do you need to do that in Access, If the data never gets imported into Access then why use Access to do that type of work, just use Excel's own features to do that. Regards John

Hi mdLueck, Thanks for the suggestion I declared those public variables in the module and it worked a treat. Regards John

Hi, I have created two public Date variables in my form as follows: Public adhocStartDate As Date Public adhocEndDate As Date This two variables get their values from the following text boxes in my form: txtStartDate txtEndDate I associated the values from the text boxs in the...

Thanks Trevor, As today is my last day at work until the New Year, it will most likely be in the new year before I can complete the work on that part [which I am looking forward to], as I have to do a handover most of today to cover whilst I'm off over the Christmas week. Thanks for all...

Hi Trevor, I've found what I was doing wrong, and it's now working. I had missed off the name of the file to export to and that was why the message was being generated. I also noted that the queries remained open and so I needed to include the close action in the macro for each query...