Recent content by thebatfink

Hi, So I have been using this code for ages, and it always used to work. I now just noticed it no longer does. Its possible I have changed some setting which has affected it's behaviour but I don't know what I have done. Basically on a report I have a field that has the potential to be...

I also notice once the button is clicked on (in the area it does allow) and the control is in focus, the whole area is then clickable. But clicking on another control and moving focus away, the small clickable area returns.. Scratching my head with it :S

Hi, I have a button placed on a form, but it is only clickable a few pixels along the bottom of the button. If you hover anywhere above this, the button is not clickable and does not highlight as if it is clickable. I have deleted the offended button and recreated it, but the same strange...

Hi, I have a Mainform with two sub forms which displays information from two tables with a 1 to many relationship. The sub forms show the data from the many side of this relationship. The sub form is within a tab control. Basically the first sub form has a single text boxes for each field in...

So I decided that I don't need the relationships in the front end because I can just specify the record source myself and add the joins in. But I see behavior I can't figure out. Image my table structure as - Table1.PartID Table1.Field2 Table2.PKID Table2.PartID Table2.Field2 Table3.PKID...

Hi. I'm not an expert by any means, but thought I would offer my thoughts on your situation. So I would suggest you see it purely as an opinion to kickstart some thinking, not a definitive answer! In your Table2. Do you have 32 individual fields named BladeID1, BladeID2 etc etc? You have...

I think this may have something to do with the backend having password protection. It would seem the relationships aren't normally visable in the front end if there is a password in place. I really would rather not remove this password as there are many applications connecting and querying the...

Hi, I am creating a form which will be used to input data into 3 newly created related tables in my backend database. Table1 is related to Table2 (1 to 1 relationship) via Table1.PK and Table2.FK Table2 is related to Table3 (1 to many relationship) via Table1.PK and Table3.FK I have...

Hi! Bit of a tongue twister topic title but heres what I want to achieve.. I have an existing datetime field named "PlanDay". I want to create a query which will select this date and also a calculated field [PlanWeek] which gives me the Week commencing date (the date of the Monday in the same...

Hi, I have a query regarding signing my database. I have purchased a code signing certificate from Comodo. I have signed the VBA project and then set users security to 'Only enabled macros which are digitally signed' but when the database is opened it still gives the prompt 'Some active...

Hey thanks for the reply. Its difficult because its a split front end / back end with a mdw file securing the front end and the mdw / backend is on the network. There are 0 relationships set on the tables. Its as un-normalised as you can possibly imagine and it would seem many illogical...

Ok.. So this is a form I am using for inputting new records. We have 3 main tables that are being updated from this form (I will simplfy this as much as possible): Table1.Product (PK - Text) Table1.ProductDetail1 Table1.ProductDetail2 Table2.Process (PK - Text) Table2.ProcessDetail1...

Hi, thanks for the post. Sorry for not getting back sooner. Basically the entire database I inherited is flat file, there are countless relationships that should be there, and many tables that could be split and related further for 2NF. In this instance, whilst no relationships were created...

Hi I am trying to update fields with a value from another table. I have two tables - Products Settings Each table has the following field which I will use as the matching key, but there are no relationships set on these tables - RefNo So for exmaple, basically I want...

Just to clarify, the relationship I am looking at is a Many to One (Inner join) type relationship? Because there are many records in Table Interleaves but they will only ever relate to one record in Table InterleaveTypes? Thanks again.