Search results

  1. A

    Problem Deleting Record?

    Ok, i've removed loads of things and HOPEFULLY it'll work how it is supposed to, but you may get some errors thrown at you due to files it needs and such but it'll hopefully be alright. Ok, when you open it, firstly open the Login form, otherwise everything will fail. Login to the Admin account...
  2. A

    Problem Deleting Record?

    Same problem. It is set to save the record before doing anything else, but i'm testing it on a record that's been there for ages, but that is still doing the same thing
  3. A

    Problem Deleting Record?

    It's behind a button so when the User clicks it and the button is on the same form as the record to be deleted. I've got almost the exact same thing on another form which also wasn't working earlier, however I sorted that one out, but when i changed the same things for this one it made no difference
  4. A

    Table Field Properties

    Ok, dw was easier than I thought. Thanks for all the help. Couldn't have done it without you :)
  5. A

    Table Field Properties

    ok got it. Just created a new reference table which holds all the field names of data types that aren't text and it is then looked up in the code to find out what it is. One last problem though, is that when the code is generated, to search for a date of birth or any date for that matter, I...
  6. A

    Table Field Properties

    Where is that Data type being stored though? Because if i make a field in the table to stored it, it is just storing another bit of information for the record not each heading, so would I not need to still look up the data type to store it? I'm just using the AddToList function I think
  7. A

    Problem Deleting Record?

    hmm the record source of the form is based on just one table not a query.
  8. A

    Problem Deleting Record?

    For some reason the form will not delete the record. I've tried two versions of the record delete function each one failing. By using DoCmd.DoMenuItem acFormBar, acEditMenu, 8, , acMenuVer70 DoCmd.DoMenuItem acFormBar, acEditMenu, 6, , acMenuVer70 It simply does nothing, but by using...
  9. A

    Split form in Subform

    Well the way it is structured is that I've got a table storing different banks, linked to a table storing the bank accounts for those banks, and a table linked to that storing transactions for each of those bank accounts. I want the form to show all of the transactions for that bank account (so...
  10. A

    Table Field Properties

    Ok, so what exactly do i need to be using in order to get the information i need. The example code you gave has an SQL string, but this won't always be for the same table or field, it will constantly be changing. Basically, i've got one drop down box where the user chooses the table or query...
  11. A

    Table Field Properties

    It helps in the understanding of it but I haven't done any coding in any of those so this is pretty new to me. Sorry to be a pain
  12. A

    Table Field Properties

    What is the SQL string in that code doing? Could you possibly explain the code? I don't know much in the way of the DAO coding
  13. A

    Split form in Subform

    That's alright no worries. I'm not sure if it can even be done seeing as it won't do it automatically with all the settings correct, but thanks anyway :)
  14. A

    Split form in Subform

    Does that work though if the form is still only based on 1 table? Won't I start getting problems with data input by trying to source the information from two tables? I had a problem like that before?
  15. A

    Split form in Subform

    Ok just put a picture on of the split form now. Basically, in Access 2007 there is a new form view which is split. It allows you to have all of your normal fields on the form like a standard form view, and then have them also shown in datasheet view on the same form without a subform. What...
  16. A

    Table Field Properties

    Would that work when the table and field name aren't constant? They are being generated from selections made from lists on the form?
  17. A

    Split form in Subform

    I'm trying to use a split form so that it shows normal controls and a datasheet. I'm able to do this easily on a normal form, but it isn't working on a subform. Is it not supposed to, or is there just some proper way of doing it? Thanks
  18. A

    Table Field Properties

    Is there a way to find the properties of a field in a table through VB? I'm looking to find the datatype of a specific field in a table or query to run different code depending on the data type? Thanks
  19. A

    Code not PROPERLY working??

    Ok all working now, thanks anyway :)
  20. A

    Code not PROPERLY working??

    think I might have found the problem but not sure of the solution. How do you put " into code without it thinking it is about to use a quote? The SQL that is generated doesn't have any "" in which i think it needs to, but how do I put it in?
Back
Top Bottom