Search results

Well that worked but I now have a problem in as far as it wont create the file, the debug comes up on this line DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel9, "qry_DetectionTraining", "c:\GPandDetectionDogTrainingLogBackUp\Training\" & strBackUpDogNameFolder &...

Hi im getting an error on a line from my export code, but I cant figure out whats wrong. The line in red is wheer the debug points to. Private Sub btnExportTrainingRecord_Click() Dim strday As String 'The date Dim sDest As String 'Where the file will be copied to Dim sSource...

Fixed! strDogName = Forms![frm_Profile]![DogName]

Hi, I am exporting a single record to a spreadsheet. The code I have works fine. The problem is I want to have the spreadsheet contain the information that is in one of the forms textboxes, in this case a dogs name. I have created a query to get the dogs name ewhich works but I dont know how...

Thtas a bit of a blow, really wanted to cascade this, have to have a rethink!

Im having trouble filtering a combobox on a form. I have two Comboboxes, one is called (FleaTickWorming) depending on what is elected in this cobo, will deside on what is available in the other combo which is called (Product). The form is a continuous form. The filtering works, in as far as it...

OK i understand, there is a link between the subform and the mainform, so it would appear that it cant be done.

If you put a listbx on a main form it will allow you to populate it and find a record (wth me so far?) If you put a listbox on a subform, the wizzard dosent appear to give that option!

Is it possible to put a listbox on a subform where it will allow you to find a record on the subform? The wizzard dosen't sem to allow me to do it!

As requested, thanks. Private Sub Form_Activate() Dim FSO As Scripting.FileSystemObject Dim SourceFolder As Scripting.Folder Dim FileItem As Scripting.File Dim r As Long Set FSO = New Scripting.FileSystemObject Set SourceFolder =...

Thanks for the replys but how do a populate a table from filenames that are held in a folder on my PC?

I have a combobox (cbo_FileNames) that is unbound and gets fed on activate from a folder Set SourceFolder = FSO.GetFolder("c:\GundogManager\BackUp\") My problem is that the file names are as follows: GundogManagerBackUp 02_12_13.xls GundogManagerBackUp 03_12_13.xls GundogManagerBackUp...

Thanks, I tried this but t dosent seem to work. I'm clearly doing something wrong. There are no records in it right now, but if you open the form and put a date into the (Date of Birth) at the top of the page, then start a couple of records, you will see the startdate carry over into the next...

I have a continuous form it has a field (DateStart) and a field (DateStartCarryOver). There is an event on (DateStart) for the (DateStart.Value) to be passed to a new record in (DateStartCarryOver). My probem is that the new record dosent get saved (i.e. it dosent get an ID so a record isnt...

Now that I have the time, I have attached a stripped down version of the database to show you what is happening. I would have put it up last night but didn't have the time.

OK I put the code in on the txtbox but its gone nuts and is flashing and showing error

Hi sorry for the delay in answering (work commitments!). In answer to your question. I need the calculation to take the last Date (DateStart) from (tbl_Seasons), it has a (Season_ID) if its any help and add the number form the field (AverageDays) to give a new date in (txt_PredictedStartDate)...

I have a continuous form. One of the fields is a textbox in date format. I want to have a calculated field in the form footer (which is also in date format) he calculation is the date field from the last record in the table + Me.AverageDays (this is another calculated textbox in the footer...

Hi I'm after some help with some calculations please. I have some Fields (SeasonStartDate), (DaysBetweenSeasons), (PredictedSeasonStart). SeasonStartDate is a Date field and holds the date that a dog goes into season. DaysBetweenSeasons is a calcuation from the previous records...

DOH! Thanks