Search results

  1. C

    multi user access

    already split, just down to making it work lol. tables on server, front end and vba on each machine.
  2. C

    multi user access

    i've got this database, happy with it and all that. NOW i have to get it to multiuser level seems very inconsitant. i think it should just work, any input from a veteran user here? my first multi user application. right now won't even let me open up 2 copies at once.
  3. C

    read only tables

    my database just went read only and i'm the only one in it, any idea what set that off?
  4. C

    option controls

    the wizard wont run! runs on other controls but nothing on options groups. just pissing me off now lol.
  5. C

    option controls

    and not even then for me! might just put a tabbed control into tabbed control as subform. weird though.
  6. C

    option controls

    if there is a property to change it could u tell me what it is? nothing seems to be there and help says wizard should open...
  7. C

    option controls

    i can't find a property to set up more options. the wizard comes up for combo list but not options group. the help file says i can copy and paste more in there but no joy! if u know a manual way to do it?
  8. C

    option controls

    ok, first i'm self taught, but THOUGHT i knew what i was doing lol i'm trying to put options on a tabbed control, i was gonna put tabs in a tab but didn't seem to want that (not aloud?). now when i make an option(radio buttons) group the wizard doesn't come up and won't let me copy more into...
  9. C

    how stable is link to excel from access?

    not sure thats a prob but wah! really wanted to load live. guess i'm looking over it....
  10. C

    argument required????

    that fixed the problem however! lol. thanks!
  11. C

    argument required????

    halts at public sub line! makes little sense
  12. C

    argument required????

    i have a script here: Public Sub LoadMaterialsUsed() If Form_frmCivilMinorJobs.toggleQuoteOnly.Value = False Then 'total of materials cost Dim curTotalMaterials As Currency 'recordset application variable Dim rsCivilCostCurrentJobMaterials As ADODB.Recordset...
  13. C

    how stable is link to excel from access?

    i've got an Access Database that links to to excel spreadsheets. its a project management system. it seemed logical to load certain excel data live everytime a project is loaded so any changes in spreadsheet update in database automatically. now, this is all working fine! well.... 9 times out...
  14. C

    link to excel is unstable

    lol i found it - it was stupid ofc
  15. C

    link to excel is unstable

    i've got a database linking to excel spreadsheets. works 4 out of 5 times but locks up randomly. any ideas? would rather it was just wrong....lol no idea where to go with it now
  16. C

    SendObject funtion

    lol that blows.
  17. C

    SendObject funtion

    I'm using access 2007 got the send object email ok... but what if i want to attach mutiple objects in one go or filter the report handed over? if i've got DoCmd.SendObject acSendReport, "rptCivilJobsSimpleList", "SnapshotFormat(*.snp)", "donna@d-group.com.au", "chis@d-group.com.au", ...
  18. C

    using vba to email reports

    ok i have a database with tables on the server, front end (forms/reports) on local machines. I now need to have a checkbox on form that initiates an automatic email to our accountant. i can do everything else, never tried to get access to send an email... needs to work on different computers but...
  19. C

    auto emailing reports

    ok i have a database with tables on the server, front end (forms/reports) on local machines. I now need to have a checkbox on form that initiates an automatic email to our accountant. i can do everything else, never tried to get access to send an email... needs to work on different computers but...
  20. C

    unique values in reports? i think...

    btw entire sql statement SELECT tblDGroupCivilMinorJobs.*, tblClients.[Client Name] FROM tblClients INNER JOIN tblDGroupCivilMinorJobs ON tblClients.ClientID = tblDGroupCivilMinorJobs.[Client ID];
Back
Top Bottom