Search results

My code is throwing an error on the DoCmd. I copied it from an old database that I built but Im now using Access 2016. Haven't done access for a while so Im out of touch. Has it changed? DoCmd.DoMenuItem acFormBar, acrecordmenu, 5, , acMenuVer70 Me.List127.Requery

Hi I need to de-Concatanate a field, there are some common things in it the field but I don't know how to go about it. The field would contain something like Cadaver (Blood) or Explosives (RDX TNT) I need to break it down into something like: Cadaver ( Blood ) or Explosives ( RDX TNT...

I have a piece of code to import a record into a Database, part of it is to update an existing table that populates a combobox. The problem I am having is that I get a message "Duplicate output destination 'txt_FullName'. If the item wasn't in the list I could understand it happening, but its...

Im trying to sort out a wildcard problem that keeps creating a type mismatch. If IsNull(Me.Breed) Then MsgBox "|Please choose an odour type", vbOKOnly Me.btn_Cadaver.SetFocus End If If Me.Breed = "Cadaver (" * ")" Then Me.Breed.SelStart = 9 Else...

I am running an Append Query [qry_AppendToWeatherFromGP] to update some comboboxes as part of an import function. My query is: INSERT INTO tbl_Weather ( Weather ) SELECT tbl_DetectionImports.Weather FROM tbl_DetectionImports; The function is: Private Sub btn_SaveImport_Click() On Error...

I have a function on my database that allows a user to import information into their database from another user (after saving the excel spreadsheet to a folder on their machine) (this database is stand alone and not on a network). My problem is that the database contains a number of comboboxs...

I have a Listbox that I want to use to go to a record on a subform. I know that it cant be done with the wizard. The records that I am looking at don't have an ID so I want to look at both a date field [TrainingDate] and a Time Field [TrainingTime]. I have set the querry up and the list gets...

I thought that I had solved this but it seems not! I have a textbox called Odours, there are four buttons below the textbox btn_Cadaver, btn_Drugs, btn_Explosives and btn_Money. On licking one of the buttons a value will be put in he textbox i.e. pressing the btn_Cadaver will put the value...

I have a textbox (Odour), that contains one of four words (Cadaver ( ), Drugs ( ), Explosives ( ) or Money ( ) ), the word is written in by pressing one of four buttons, this works fine. I now want the user to write in between the the brackets and only the brackets. For example: The textbox...

Ive had search around the forum and have found a few threads about this but cant pin it to anything that Im doing. The error occurs when I choose from a combobox after having chosen a record from a listbox and then choose the same record again from the listbox and then choose from the combobox...

I need to open a PDF file from a button, now I know th easy way to do this is via the hyperlink in proporties. The problem is the file may or may not be present. It will always be named exactly the same. I'm assuming that I need to do this in VBA. I have done the code to check if the folder...

Hi cant seem to find what Im trying to do, which I think is quite simple I have a unique identifier (DogID), its the users reqposibility to put that number in, but I need the code to check the table to see if the number is already in use. I suspect I should be using the DLookUp function. But...

I'm getting a runtime error 13 on this line of code. Its a piece of code to make a directory, but I cant see anything wrong! strBackUpDogNameFolder = "c:\GPandDetectionDogTrainingLogBackUpsandReports\" & Forms![frm_Profile]![Discipline] \ " & Forms![frm_Profile]![DogName]"

Im having a bit of trouble with the design of my DB. The DB is a dog training DB. Each dog has a profile with its breed, Name etc and a DogID (this is an autonumber and is the Primary key) Each dog undergoes training each day and that is recorded on a subform. The subform holds a TrainingID...

I have a form with a subform. In the footer of the subform I have a combobox that get the filenames of excel spreadsheets from a folder. I have a button (no code on it yet) that I want to press and import that spreadsheet into the table for the subform and associate it with the main form. How...

I have the ability on my database to export one record to excel. The raeson for this is so that I can email the record to another person. The record has an autonumber ID. The person that I share the information with my well have a different record with the same autonumber. If they try to...

Sorting a list of Files I have a BackUp and Restrore from BackUp procedure in my my database. I can backup to a spreadsheet and the spreadsheets are renamed to include the date of the backup. When I restore from the backup an unbound combo is populated Set SourceFolder =...

I have a procedure to export a record to excel. One of the fields is a date field and its set at medium format i.e. dd-mm-yyyy. That is how it appears i the associated tables and form. I want to include that date in part of the exported filename. I created a string: strday =...

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...

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...