Search results

I'm amazed at how quickly I got a reply, thanks a lot. I realised that the data was there because when I printed a Report based on the form the data aaaaaa bbbbbb was displayed. I understand that it's not really meant to be displayed in the table (but it's there) but I couldn't figure our how...

I have a form based on a table that has a memo field. While on the form if I enter data in the memo field with a line break the underlying table is not updated with the data after the line break. See attached image

Thanks again for taking the time to reply at this time of year. I think I get it now. Have a nice Christmas

Thanks for your prompt reply. Perhaps I'm not explaining myself properly (or don't understand your answer). I have a field "fish type" in TblCatches which is related to another another table "TblFishType" which has 4 records, one of which is "All fish types". When I select "Salmon" on...

I attach a slimmed down version of a db. When I select a specific "fish type" from the Combo Box on the form, I get the answer I expect. If I select "all fish types" nothing is returned. What is wrong with the onClick code of the command button?:banghead:

Thank you very much for your prompt reply. Knowledge is a wonderful gift.

I have a form that has only two controls - name and district. When I open the form it fills the whole of the work area in access. I have looked everywhere but cannot find how to set the height property. I've tried using "Pop Up", and altering the height property of header, detail and footer...

Thank you...I'll try that. In my learning, I've used the Immediate Window but haven't really studied how to use it to it's full potential for debugging purposes. This thread problem has prompted me to now go and find out more about "Debugging" and the use of Immediate Window and based on your...

I set the data source of the combo as a table called "TblPoolSelect" in which I set the Primary Key to PoolSelectId (Autonumber) and the only other field I listed in that table was "PoolSelectRange" in which I entered 6 values...ranging from "Catches 1-22 Salmon" to "Catches 23 - 32...

Thanks for taking the time to answer my query. I'm an enthusiastic amateur and your code for error handling is well outside my comfort zone.

Guys.....you are all correct in what you say. I absolutely agree that this Forum should not be a place where inexperienced Access users (like me) come and pick up "unearned" code snippets. There does come a point however, where you end up near in tears of frustration after you've spent hours...

Thank you very much....I'll try these options and let you know

Thank you for that but I still have problems. When I add Debug.Print Combo6 at the beginning of the code and Debug.Print strForm at the end of the code I get weird results. For example if I select the first combo item I get Combo6 = 3 and strForm = CathchesSeaTrout in the immediate window. I...

I have a form with a combo box that has six values being pulled from a table "Catches 1 - 22 Salmon", "Catches 1 22 Sea Trout" plus another 4 values. I have six corresponding reports called "Cathces122Salmon", "Catches122SeaTrout" plus another 4 reports. What I want (obviously) is to open the...

I saved the "BackUp.vbs" file in my database folder and double clicked that. On checking I found a copy in the folder.......path..... "G:\Bills Folder\Trial_Save_Database\" called "Copy of Database 2012-11-08.accdb" Thanks again for your help

Thank you very much for your prompt reply. I have now got it to work and saving the backup in a folder called "Trial_Save_Database" by adding a backslash as shown.. Dim FSO Dim BFilePath Dim Varnow Set FSO = CreateObject("Scripting.FileSystemObject") Varnow = now vardatefile = "Copy of...

Thank you very much for your prompt reply. I have modified your code but can't get it to work.... Dim FSO Dim BFilePath Dim Varnow Set FSO = CreateObject("Scripting.FileSystemObject") Varnow = now vardatefile = "CopyTargetdbat" & Year(Varnow) & "-" & Month(Varnow) & "-" & Day(Varnow) &...

I'd like to have a button on my dashboard that gives the user the ability to back up the database and save it with a different date. For example, existing database called "Fishing.accdb" and I'd like to have code behind a button that allows the database to be saved as "Fishing0711.accdb" I'm...

I have a main for with sub form. The main form has personal details and the sub form has list of fish catches per person. The main form has several fields like Name and Surname...I would like to put a a search facility on the main form based on Name and Surname fields that are linked to the...

Thank you both for your prompt replies.....greatly appreciated