Search results

  1. M

    Question Auto fill in query parameter with a forms field value + more.

    hi it says it contains invalid sytnax - i may have entered an operand without an operator.
  2. M

    Question Auto fill in query parameter with a forms field value + more.

    is this right: Forms!Need LLPG Action!Submitted By where - "Need LLPG Action" is the form and "Submitted By" the text box containing the originators name Where do I add this though - in the macro containing the send object command or the query which generates the data for the report. If it...
  3. M

    Question Password Protect Access 2007 form.

    Any suggestions of what i need to do
  4. M

    Question Auto fill in query parameter with a forms field value + more.

    thanks ill give it ago this morning and see where i get. i couldn't use the "to" command from the macro because the email recipient changes depending on who submitted the issue. In reality 2 people recieve emails from originators but potentially those 2 must send to anyone within my organisation.
  5. M

    Starting out right

    Hi, things nto note. We just upgraded all our PC's from Office 97 to 2007. Most databases worked fine however the 2 biggest problems I had were - new filename - accdb instead of mdb - complicated VB often had errors (generally deleted the function or renamed) Does your company have an IT...
  6. M

    Question Password Protect Access 2007 form.

    Right here is what I have :: strPWD = DLookup("Password", "tblllpgpassword")
  7. M

    Question Auto fill in query parameter with a forms field value + more.

    Right guys. I have created a workflow database - its not complicated, at least I created most of it so it can't. I have a form which displays details of what needs attention by admin. Once the admin has done the work they email the originator back with a report which includes all the...
  8. M

    Question Password Protect Access 2007 form.

    Hi, In theory you could just copy your users into the tbl in the example and edit the table with new passwords and the relevant security group....then edit the code so it opens the form you want. Thats the easy option anyway. otherwise you'll need to edit more of the code - im failing at that...
  9. M

    Running Access without Access installed

    if you have access 2007 then they offer a free front end I think...
  10. M

    Question Password Protect Access 2007 form.

    Hi, Thanks I only intend to allow 1 user (or group of users under who know 1 passowrd) into the forms so I don't need security groups/user information. I copied the login form, deleted parts i didn't need ...got most of it working. However the Dlookup will not compare the password to input...
  11. M

    Question Password Protect Access 2007 form.

    Hi, I have a few forms I have password protected. This works fine because I use an input box on form load which asks for the password. however input boxes do not easily allow you to mask the input. This code was downloaded from the internet and changed to suit my application. How can I...
  12. M

    DTS to SSIS

    Hi, We are upgrading an application from SQL 2000 to SQL 2005. We have a few databases on a SQL 2000 server. These have DTS packages. Our supplier apparently converted them and told us to save them onto the application server for the new version of this application. However we cannot see...
  13. M

    Hard Disk Replacement Help

    I have tried connecting just one drive (new one) to my primary slot on the cable and booting but it just stops booting on the first screen. "Checking Primary master..." is the message and normally it would get through a number of these checks and boot - this time it stops on that. Windows...
  14. M

    Hard Disk Replacement Help

    Right need some advice...how do I make the hard disk bootable. I stuck my new disk into the PC as slave, it wouldnt boot as master, went through the installation process and selected the 500GB disk as the source - erase all disk, install GRUB onto it and ALL the OS - i ignored old disk...
  15. M

    Ubuntu 9.10

    Hey guys Anyone tried this - I have it running dual boot and I am quite impressed. I am a linux beginner but so far it has been easy to use.
  16. M

    PHPbb Beginner - I want a forum

    Any help for someone trying to create a forum ? I would like to try and create one from scratch, I know there are free hosting ones. (don't worry it is not for database but for mybrother + his drink).
  17. M

    xcopy log file

    Hi, im not sure...I am pretty sure the /D switch which copies files changed on or after the specified date. If no date is given, copies only those files whose source time is newer than the destination time. If your PC is newer you could use Robocopy which is slightly better - think that is...
  18. M

    Hard Disk Replacement Help

    if it does cause a problem I will just stick the new ubuntu onto it...
  19. M

    Hard Disk Replacement Help

    Ah so before I copy create the partions...i get it. then copy the image to the small one - OK. Just if this doesnt work and I need to use the restore disks do you know whether or not the larger hard disk would be an issue? it would be the only hardware change for the PC since it was bought...
  20. M

    Hard Disk Replacement Help

    I have been told to use Clonezilla but apparently it is a bit tricky to use. If what you say is fine, i will create an image of the old harddisk, copy that image to my new one and create a 2nd partition on it...would something like Paragon Partition Manager do this for me? thanks
Back
Top Bottom