Search results for query: *

Hi Folks. Just trying to get a bit Excel happening, not my forte, but can't work out why I'm having this issue So 3 sheets. Entries/Breeds/Colours I'm using the Unqiue/Filter combination to get the base of the data I want. With the Finction below in F1, I get the following What I'm trying...

I have used this process many times before but I'm can't get this to work main form: (button click event) ... strSexVal = 2 DoCmd.RunCommand acCmdSaveRecord DoCmd.OpenForm "frmPetDetails2", acNormal, , , acFormAdd, , Me!PetID & "|" & strSexVal frmPetDetails2 form: Private Sub...

I have a form that has a subform attached that has some weird behavioural problem basically when I click on a Prefix field and using onclick and a requery it should update the subform. This works in one instance but not for others. When I open the subform on it's own it shows the correct data...

Have combed the net and have not found an answer to the following. Basically a books program for a club. Backend tables are based upon the TransactionsID in the Transactions table. I wish to be able to double click on a record on a continuous form to open a record on a navigation tab subform...

Hi folks because of changes at Google Maps API I'm making some changes to a maps page I have. The data creates the array from MySQL using PHP. Cutting out of the un-neccessary stuff I end up with this. The code below shows the map but it doesn't show the markers. Getting no errors so I...

Hi Folks. I couldn't find an answer to my specific problem so came to the gurus I export data from several qureis to the same Excel sheet using DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel12Xml, "qryTS_Shows", strFileName, True DoCmd.TransferSpreadsheet acExport...

I have a bit code that checks to see if a client has two or more records in a query and shows a different form based on the result. Simple enough. It works most of the time fine. However, occasionally it doesn't work and returns zero count even through there are records in the query. Example...

Hi folks Got a weird problem. I have a report that prints fine until I put a watermark on it. Then the text fields stop showing. This is before adding And this after adding a background image I've tried gif jpg png all with web colours. the image is only about 2.5cm wide. I have...

Hi folks Using PHP/MYSQL and some Javascript for a site, where at some stage, people will fill out an address. I am trying to return the postal code automatically based upon the Suburb they select from a dropdown. The postal code is stored with the suburb in the database. My problem is that...

Hi Folks Got a form(sub) with a weird problem. Bit hard to explain but the attached video says it all. I have tried the subform in datasheet mode with the same affect. The cascading combos are working fine just not displaying properly. When the PetType is selected sets PetTypeID to that...

Hi Folks Got a report and in it I have 25 Text fields named txtName1 .... to ... txtName25. the fields were setup and then copied and pasted then the name changed. I'm using the following to seperate out each char in the pet's name (me!PetName) and put it into each of the text fields (i.e. 1...

Hi Folks I have two tables, one that stores pet booking info (tblBookings) it has a field in it called cage. this is for the allocation of a cage at time of booking. I also have a table (tblCages) with a list of all cages we have for both dogs and cats. What I'd like to do is show a list of...

Hi folks Couldn't find anything about this in the search so... Using Access 2013 and have a few reports setup. I have a system setup table which a bunch of options which the user can change based on their needs. One of those fields is an attachment field for their logo. What I having...