Search results

  1. P

    Question Numbering each Excel Import

    I have a need to do multiple imports from Excel each week, each import needs to be individually identifiable. Is there a way to create a unique ID for each import I do (as opposed to each record). Thanks.
  2. P

    Delete records as table updates

    Hi all, looking for some feedback and advice. I have a Access backend linked to a SharePoint list. I run daily updates from several sources via the Access end to update the lists. One of the updates I run takes well over an hour (sometimes 1.5 hours, depending on the network). What I'd like...
  3. P

    Adding more records to a record

    Hi, I've tried to search around for a solution to this as I won't be the first to have asked about it, but I cannot think of a term to clearly define it and what I have searched for doesn't come up with what I'm looking for. We have a Db that holds data on multiple projects (Project A...
  4. P

    Switch in a qry

    Hi all, I need to use the Switch function in a query. I have a query that gets the first letter of a Position Number (D, V, C etc. that works fine). Then, I take that query's results, and use it as a sub query in a second query. I then need to show a value dependant on what is returned...
  5. P

    Compile Error help needed please

    HI, I have no doubt this is something very straighforward I cannot see, but when I try to comile my Db, I get an error saying; Compile Error: Label not defined. I've checked through, but cannot find the problem, it tells me "Resume Exit_cmdEndAfterCalendar_Click" is the line causing...
  6. P

    on click for cmds

    Hi, code noobie, so would love some help here. I have a form with several controls (mostly txt and chk). When I click a cmd, I have set some of the controls to Visible = False and some to Visible = True depending on what the user needs to see at the time. What I'd like to do, is if the...
  7. P

    combo box view

    Hi, I have a combo box on a form, but the data in the combo is wider than the object on the form, so some of the details are cut off when you scroll down. What I'm wondering is, can I make the cbo object on the form a smaller size, but when I hit the dropdown arrow, the choices appear in a...
  8. P

    Object visibility

    Hi all, I have a form used for a couple of parameter qrys, what I'm trying to do, is hide some objects on the form, but on the On Click of a button, I'd like to make a few more objects visible via VBA. I've tried; me.txtDate visible = true and forms!frmReportParameters!txtDate visible =...
  9. P

    List of reports in dropdown

    Hi, I have a form for Reports and on it I'd like a dropdown that displays the reports that are available (or maybe queries, I don't know which yet) so users can hit the dropdown, select their report, enter some parameters (just dates) and then I've just got a button that runs the report...
  10. P

    2 qry to 2 cbos

    Hi, My db tracks job numbers and who is in them. I have a form with a job number and two options; the 'owner' of the role (substantive occupant) and the 'current' occupant (if someone is on leave, or acting in a second role). I have a cbo to a query based on tblPeople to get the occupant's...
  11. P

    Archiving data from a form

    Hi, my db has a view data form frmJobsView. When I am done with a job (the db tracks jobs and workers and manages the status of a job) I would like to open the view job form and have a check box that on update to true, sends that job from the tblJobs to the tblJobsArchive. Does anyone have...
Back
Top Bottom