Search results

  1. A

    Data not importing from .xlsx file

    changed, but with no difference,
  2. A

    Data not importing from .xlsx file

    I have a form to upload data from a XLSX file to an access table. When I click upload, I am getting a blank record, the data does not seem to copy over: File Selector: Private Sub Command9_Click() 'Requires reference to Microsoft Office 12.0 Object Library. Dim fDialog As...
  3. A

    You can't delete the table '|'; it is participating in one or more relationships

    I ended up exporting the data into an excel file and then importing it. It has never happened before. Not sure why it is asking about delete when I am doing a simple export.
  4. A

    You can't delete the table '|'; it is participating in one or more relationships

    I have two identical copies of an access database (one has two new features), I want to export the data from one db to another, when I do, I am getting this error: You can't delete the table '|'; it is participating in one or more relationships Not sure what the issue is?
  5. A

    upgrading a standalone database

    Fantastic, thank you everyone, I think a split database is the way to go forward, easier to upgrade the FE without any complications and allows user to share it with other users on a network. I will look through the links suggested for that. My next question is, if I add an extra field or table...
  6. A

    upgrading a standalone database

    Hello. I have a standalone database that is being used by multiple users (it is not a split database as it does not run over a network) and each user have their own copy on their laptops My question is, If I upgrade or add a feature to the interface, how can it reach the users? Also, if the...
  7. A

    vBA .exe file to update record

    Some great ideas guys, thank you. So, when I went back to my database, I realised that the expiry date was not being looked up from a table, but was hard coded into a VBA like below: Dim dtExpire As Date Dim DateDiff As Integer dtExpire = #6/1/2030# 'I need this to be...
  8. A

    vBA .exe file to update record

    Hi. I have a table with product expiry date, when the database opens it checks the expiry date, if the license has expired it will notify the user and close down. When the user purchases a new license, I want the user to run a VBA script that I send by email that updates the record in the...
  9. A

    Cross Tab to show actual values

    I do not wish to show a summarised value for the row and heading in a cross tab query, I want to display the actual value. The value is a number field. How can this be achieved?
  10. A

    Formatted Spreadsheet Export

    Sorry guys, this is my first time with Functions/Modules. I have created a module and saved this code to it: Code Tags Added by UG Public Function SendTQ2XLWbSheet(strTQName As String, strSheetName As String, strFilePath As String) ' strTQName is the name of the table or query you want to...
  11. A

    Formatted Spreadsheet Export

    How to I assign the function to a button to execute it? I assigned it to a macro but it came up with an error message.
  12. A

    Formatted Spreadsheet Export

    Hello, I am looking for a simple script that I can manipulate to do the following: - Opens a new spreadsheet - Exports data from a query to it - Wrap text the headings and apply formatting - Apply 3 conditional formatting rules on the data Any help would be greatly appreciated. P.S - I am...
  13. A

    Cross tab filter from Combo

    Great, thank you. It works! PARAMETERS [Forms].[Form1].[txtCustomerID] Text (255);
  14. A

    Cross tab filter from Combo

    Thanks guys. something like: Dim comboBoxText As String comboBoxText = Me.YourComboboxName.Column(1) Will this work in SQL view..it sounds like VBA
  15. A

    Cross tab filter from Combo

    I have a perfectly working cross tab and I want one of the filter fields to filter from a combo on one of the forms. I am getting the error: The Microsoft Access Database Engine does not recognize Forms![Form Name]![Comboname] as a valid field name or expresion.
  16. A

    Allow full menus without restart

    I have disabled "File" ->"Options"->"Current Database" "Allow Full Menus". I want to enable it from a password protected form from a click of a button without restarting the database. I have the pass by shift key disabled. Any vba scripts I can use to achieve this?
  17. A

    Calculated Field in Dlookup

    I am using a DLOOKUP which is returning no values, wondering if it is to do with the use of a calculated field: A_Score_: DLookUp("[A_Score]","tbl_att_grade","[A_Grade] = ' " & [Grade] & " ' And [GradingSystem] = '" & [GradingSystem_] & " ' ") I wish to return the A_Score from the table...
  18. A

    Checking License Key using HTTP

    Sorry to hear about your mum..may she rest in peace. OK, so I have had a chance to re-look at the modified coding, I am facing the same errror: ie.Document.Forms(0).submit I reach the landing page with the date and small rectange block next to it, but after that it doesn;t do any of the...
  19. A

    Login program issue

    It appears that the script is looking at the first record in the table only as oppose to looping over all records, the first user in the table allows the login but the others don't. Can anyone see any obvious mistake?
  20. A

    Continuous Form defaulting to single record form

    I have set it to continuous form and tried data sheet view in the default view property but the form ignores these properties. When I switch the default view it works but then defaults back to single. I have created the form from a wizard so the properties should match all other continuous...
Top Bottom