Search results

  1. K

    Loop through Subform Records

    Hi, Am working on a database that will hold some data for two departments. The data from dept1 is entered, when entered I would like it to pass to dept2, so I have four tables say; dept1header dept1lines dept2header dept2lines I am able to get the header information from the input form aka...
  2. K

    Missing String Parts after a Space

    Hi, I have a small bit of VBA code that looks up form fields and the data within those fields is set to a string. The problem is some of the data within those fields has a space, any data after that space is missed the full string is missing. Dim stAppName As String Dim stEmailTo As...
  3. K

    Referencing Form Fields

    Hi, I have built a small application to send emails in C#, I am now trying to get it to work in Access. If the email address are hard coded into the C# app and a button pressed in Access the emails will send. I have changed the C# app to accept arguments ie a To and CC email addresses. I am...
  4. K

    Question Two fields, one table design?

    Hi, I have a question about the design of tables and relationships... What’s going on is I have two tables, one is say Flights, and the other is Airports. I have a departure_airport field and a arrival_airport field, I have a one-to-many relationship on the departure_airport field, what’s the...
  5. K

    Update ALL Lines of DataSheet

    Hi, I have a sub-form that is in the datasheet view, am using an Excel form to import the data after the import some of the AfterUpdate functions are being missed so I have made a button to call the AfterUpdate function. The problem is that the button works but for only the selected line of...
  6. K

    Capture Form as Image

    Hi, I have a problem printing forms that include charts, the problem is not with access but with the printer. A number of printers have been replaced and on the new ones we are unable to print charts completely, some of the data is coming up in black boxes, this appears to be the print driver...
  7. K

    Update data with Button

    Hi, I have a form in Tabular view, this form is based on a query I have added a button to the line of data so when pressed it will update the data in one of the fields. The field am trying to update has data within it, this field is also used to select the data in the query, what am trying to...
  8. K

    Automate LineNumbers for Sub-Form

    Hello, I have a database that has a sub-form, for the sub-form I would like to add line numbers for the different lines of data, this will help keep things tidy and in the correct order when referring to paper work. My question is how would I automate something like this, I can add in the...
  9. K

    User Login - Enable / Disable Account

    Hi, I have been playing around with some Access tutorials on the Internet, am interested in how I would go about changing a User Login to also have enabled and disabled accounts. Here is the site; http://www.databasedev.co.uk/login.html On the cmdLogin button I have added the following...
  10. K

    Hide Access Application & Open Forms

    Hi, After coming across the below code and having a play around I have come to a brick wall. I have been able to get my splash screen up, then after that my Main Menu Form with the Access application hidden, but then when I click on any of my buttons to open other forms nothing...
  11. K

    TransferSpreadsheet Prompt User for File

    Hi, I have been looking into transferring data from Excel to Access, I have now been able to successfully do this using a Macro, however the filename / location is static in the Macro. How can I prompt the user to select the file, like in the Get External Data wizard? Here is the Macro...
  12. K

    Import Data from Excel to Relational Tables

    Hi, I have a database with two tables joined with a One-to-Many relationship, how would you import records over the two tables from one sheet. The sheet will have the enquiry detail which is one table and then the lines of the enquiry the other table. I have red up that an INSERT...
  13. K

    Requery Subform to Update Data

    Hi, I have a main form which has a subform that data within the subform comes from a query, I would like that data to update when I have entered in new data without having to close the form, however all my attempts seem to have fail so far here is what I have. Three forms; frm_Main_Form...
  14. K

    Duplicate Count

    Hi, I am using a spreadsheet that keeps a list of price requests, within that sheets is a basic formula that keeps a count to how many duplicate price requests there have been against a part number, how ever the spreadsheet is getting large and slow so Access would be better to handle a...
  15. K

    Update Three Tables with Single Form

    Hi, I have three tables; tbl_Exchange_Rates_CI Currency, RatesCI tbl_Exchange_Rates_MU Currency, RatesMU tbl_Exchange_Rates_PS Currency, RatesPS They all have the same data but each have one different felid, is there any way that they can all be updated at the same time? Thanks
  16. K

    IIf statement with Calculation

    Hi, I have the following IIf statement; MarkupCost1: IIf([Markup]='',([Markup]*[GBPCost]),[PSP]) What am trying to do is if the [Markup] is blank then show the [PSP] value, but if the [Markup] is not blank then do the calculation ([Markup]*[GBPCost]). The above IIf shows the [PSP] value when...
  17. K

    Table Field with IIf and Data Entry

    Hi, I have a table with a felid that is called QtyCI, I need this field to be multi purpose. First it needs to perform an IIf statement; IIf([MBSTQT]>99999,"STOCK","003") Then if needed it needs to be typed over and data entered into the field. Can this be done or it best to have them...
  18. K

    Update Data in Table form ODBC Database

    Hi, I have a table in Access that I have imported from an AS400 using a Macro, here is the Macro that I used; Transfer Type: Import Database Type: ODBC Database Database Name: ODBC;DSN=mvxr10;TABLE=DATA09 Object Type: Table Source...
  19. K

    Simple Search Form

    Hi, I am trying to create a simple search form, the form has a text box and a button. When a number is typed into the text box and the button is clicked I would like the another form to open on the record that was typed in. The data in only in one field not to complicated but can’t seem to...
  20. K

    Update SubForm Data

    Hi, I have a form which has a subform, on the form there is a button where a user can open a form to enter data into the database, this data once in the database should be displayed on the subform but to update it I have to close the form down and reopen it. How can this be updated when the...
Back
Top Bottom