Search results

  1. N

    Select as you type ListBox

    Hi All, I have a listbox (lstJobs) on a form (frmJobStatusList) which contains a large list of jobs. Users can double click on the listbox to open a job form which contains details about the job. Currently when the listbox is selected people can type a character which takes them to the first...
  2. N

    Dlookup with filepath as criteria

    Hi All, I've changed the way we store our quotations in our quoting database. Where before we would store them under the project number, we are now going to sore them under the client name first and then have a subfolder for the various projects. In order to move over all the old quotations...
  3. N

    Create appointment in Outlook with formatted body

    Hi All, I am wanting to setup appointments in my Access database, and then have those appointment populate to Outlook 365. I have setup the table (tblAppointments) with the necessary fields and have created a form to handle these (frmAppointments). I have some VBA code which is mostly working...
  4. N

    Send Attachment via Outlook Email

    Hi All, I've been trying to get this block of code to work for a while now and can't seem to find the answer. I have found some code and edited it to suit (from: http://www.devhut.net/2014/10/31/createobjectoutlook-application-does-not-work-now-what/) For some reason this works perfectly when...
  5. N

    Duplicating records to same parent record

    Hi Everyone, I have another issue. I have borrowed some of Allen Browne’s code for duplicating a record and its related subrecords from http://allenbrowne.com/ser-57.html I have this assigned to a button on a form [frmItem]. The form allows staff to add materials and labour (Inputs) to an item...
  6. N

    foreign key null in query access

    Hi Everyone, So I have an issue. For some reason I cannot get this to work. :banghead: I am trying to design a query to populate a search form that lists all jobs in the system. This will show the JobID (from tblJob) and the contact name (from tblContact), plus a number of other...
  7. N

    MySQL backend, primary keys and #Deleted

    Hopefully someone can shed some light on this issue I am having. I don’t know whether this is one issue or two… The gist of it is… 1. When I create a new record in my form it doesn’t automatically show the primary key (JobID) 2. When I try to assign a client to the...
  8. N

    Copy value from one field to another

    Ok. This might have been asked or solved somewhere else but hoping that someone can tell me how to do it or point me in the right direction. I have some subform (fsubItemInput) on another form (frmItem) which allow me to add multiple Inputs to a quoted Item The background tables are...
  9. N

    Table design (linked vs unlinked)

    I am in the process of designing a database with a form for entering jobs like the attached image (Page1). I am wondering what the best way to create the tab and subform for Items (which will be linked to my Job table (tblJob). I have tblItem which will hold info for each item as it is...
Top Bottom