Search results

A1. At the moment I allow free filtering but may switch it for a couple of comboboxes instead if its easier. A2. The recordsource at the minute is a table, queried by the subform which is displayed on my main form. I dont mind changing the forms about. Making the subform get its data from a...

Hi Isskint, Thank you for your prompt reply. The only reason i am using a function is because im letting the user use the filters on the subform then click the export button to put the remaining data into Excel. From what i have read im sure that the DoCmd.TransferSpreadsheet ignores the...

Hi all, I use the code below to copy data from a subform to Excel. However, some of the dates are coming out "mm/dd/yyyy" instead of "dd/mm/yyyy" (not all of them though). Is there a way to make sure they all come out "dd/mm/yyyy"? Thanks in advance. Private Sub cmdExport_Click()...

This worked, thank you :)

Hi all, I think my database is being bloated by images. I have done some research on how to avoid this, and have followed some instructions on creating a table with the paths to the images. I have inserted an object frame and created the table but dont know what to do now.... The...

Hi All, I have a huge amount of data in a subform and i am trying to speed up how quickly the data is loaded when i open the form. Any suggestions to speed it up would be great, maybe there is nothing i can do but worth a try. All the data is pulled from a table but there are two formula...

Thank you CJ_London, I have just checked an our IT department has disabled the Trusted Locations. Its fine, hopefully there will not be to many updates needed to the front end so newer version will not need to be released. Because once they click enable content it doesnt prompt them again...

Hi CJ_London, I think I figured out the problem while you was typing this reply, apologies. After enable content is click and the database the next time it is opened it is fine. The function runs on a query that runs when the database is opened. Basically my main form has a sub form with...

I think i have found the problem. The function runs in a query, however the query cannot run until it has data. On the first occasion when someone opens the database it asks them to "enable content". Once this has been done the database works fine until i send out a new front end. Is there a...

Hi Gemma, Thanks for your reply. Do you mean split the database again into a front and back end? If so i just tried that and got the same error. If not then im sorry I dont know how to do it. Chris

Hi all, Looked online and cannot find anything to correct this. The module is not named the same as the Function which seems to be the popular reason for this. When the Database is opened by a new user or i send out an updated front-end to current users an error message appears saying: -...

Hi all, I have a subform with the filters enabled. I have a macro that moves any filtered data to an Excel workbook. However a little thing i want to correct before i send to the team is the filtering. On the first filter it has a list of all the values that are in that particular field, but...

Thanks Arnelgp, I could follow what your original code was doing but not sure about this change. The data isnt coming out as it should. Is it possible the format - Format(startDate,'yyyymmyy') should be Format(startDate,'yyyymmdd')? Thanks again.

Worked exactly as it should!! Many thanks, however you code has made me discover some admin have been inputting data incorrecty. We have records where one ends mid month and the next records carries on from the next day... e.g EmployeeID | StartDate | EndDate 11111 | 01/01/2016 | 20/01/2016...

Thanks for your reply, it is - SickRecs

I still havnt figured this out if anyone can help. Still doing it manually :(

Hi All, I have a subform that displays all records from a table. I also have a form that displays a single record from the table. What i want is when someone double click the record on the subform all the details of that record open in the form that displays a single record. What is the...

I have done it in the past via Excel VBA but wouldnt know how to do it in Access VBA. The code I wrote in Excel was Sub SickDates() Dim lRow As Long, i As Long With ActiveSheet lRow = .Cells(.Rows.Count, 1).End(xlUp).Row For i = lRow To 2 Step -1 If...

Hello, The software we use will not let the data be input across the month end boundary. Therefore when I pull the data 'out' into Access via Oracle SQL it comes out split in the individual months. However for sickness monitoring and for it to be easier to read the data, it would be better...

I give it a go but it doesnt come out as i wanted. It gets the MIN and MAX dates but if there is a gap between records it should be a new record (different period of absence.) Thanks Chris