Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: bistec
  • Content: Threads
  • Order by date
  1. bistec

    hiding forms with variable name

    Hi I'm playing with passwording forms and although security is not a big issue I'm finding that I'm having to add a few more passworded forms. I though about usernames and passwords but it doesn't really fit into the big picture. I've created a function (below) that I think will do everything...
  2. bistec

    Change Access field format using vba

    Hi Is it possible to change the format of a field via vba? I'm adding a field to a remote backend db using the following; <snip> Function AddNewField() Dim db As DAO.Database Set db = OpenDatabase(&quot;D:\nbm\smdata\smdata.mdb&quot;) db.Execute &quot;ALTER TABLE jobs ADD...
  3. bistec

    linking tables externally

    I'm trying to use an seperate mdb file (like an update to run at the remote site), to create a new table in the backend db to the frontend db. I've had a look at &quot;TransferDatabase&quot; but that seems to only be configurable to run in the frontend db only. Creating the new backend table...
  4. bistec

    What's the quickest and easiest way

    I have an main form with subform and I'd like to add a new record to the subform. That bit is not so bad. I need to get info from another table to fill in on the new record when it's created. So do I open two record sources with SQL get the values from one record then add the new record to...
  5. bistec

    Trying to convert field data to string

    Trying to take the data out a field from several records and create a string using VB. e.g. Description (field) -------------------- Lounge Chair Television etc I want to get this output as a string variable Lounge, Chair, Television, etc I've been trying to get the following working but I...
  6. bistec

    Want to open form from list, after form closed, refresh list then move

    Long discription I know but... I have a form that returns a list of records via SQL in VBA. User can dbl-click to open form with full details update, edit etc. After details forms is closed, the list does a refresh to show changes. What I would like to do is set a bookmark and return to...
  7. bistec

    Permission Denied when making DLLs in VB

    I'm developing VB DLLs to be called by ASP pages on the web. However I find that after I run the ASP pages that calls the DLLs, the next time I try to &quot;make&quot; the DLL, VB gave me Permission Denied error. I was told using MTS will help. But so far, I find that it only helps a bit...

Part and Inventory Search

Back
Top