Search results

  1. T

    Checking for NULL with Report_Open - broken?!

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

    Form Command Button Clickable Area problems?

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

    Can't cycle through records on a subform

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

    Multi-table form - relationships in front or back end?

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

    SQL Query to return Week Start Date from a given midweek date?

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

    Digitally Signing the Access VBA Project

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

    Fields on a form driving me nuts.. Why can't I type into them?!

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

    Update field from field in another table?

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

    Simple relationship table design, Why ID numbers?

    Hi, I have a database with no relationships and it serves its purpose, but it would probably give experienced database programmers a heart attack :) I'm looking for the first time personally at introducing relationships for referential integrity (which has to be all considered and performed...
  10. T

    Execute SQL statement and display results on a form using VBA

    Hi, I have a form which builds and executes SQL statements based on the users inputs on some checkbox and textbox controls on a form. Currently I then take the formed SQL, create a temporary query and then open the newly created query read only. The result is the query output in the normal...
  11. T

    UPDATE with LEFT JOIN

    Hi, I have a select query.. SELECT [table1].[field1], [table1].[field2] FROM [table1] LEFT JOIN [table2] ON [table1].[field3]=[table2].[field1] WHERE [table2].[field2] = true and [table2].[field3] = false; which works fine and returns the results I want.. But I now want to make that into...
  12. T

    Manipulating user options of multiple checkboxes

    Hi, I have a form for creating new records in a table which contains 2 individual check boxes (which store their boolean values in fields in the same table). What I want to do is allow the following conditions - True, True True, False False, True but prevent - False, False Is there...
  13. T

    SQL Update and error capture?

    Hi, I am using a button to trigger an Update SQL statement. I'm worried about situations such as, it gets half way through and encouters an error updating a record - how I could recover from that. I'm assuming that it attempt to perform the update looking for records that may cause an error...
  14. T

    Starting my first database.. Pointers for this situation?

    I am about to embark on a new Database (my first). I've armed myself with a few books and I am working from an old database which we are trying to "improve" so if all else fails I will simply add to the current in the same way it is built, but I'm asking myself the question, is the current the...
Top Bottom