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 Chriss Miller 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: GK22
  • Order by date
  1. GK22

    distribute databases

    Hi to all, Is it possible to make a function to forbidden a duplication of the database. Something like licencing. You give one person a number and he can open 1 copy of the database. If the function is there, can someone tell me how? Thnx in advance Gerard
  2. GK22

    Loop trough a recordset

    I made a form based on a recordsource named "ProjectList" On this form is a button "CountOff". I wrote next code: me.countoff.caption = Dcount("[worknr]","[qrysubform1]", "[leadnr] = " Me!leadnr) In this case: the...
  3. GK22

    hiding subreports

    Is it possible to hide a subreport when no data is in it? In which place is the subreport coming? In the details? I have a groupheader: Company I have a details: Persons I want subreport: Projects where persons are dealed with Is this possible and so: How?? Thnx in Advance, Gerard
  4. GK22

    allowbyPasskey

    thnx maquis, looks fine, I will try Gerard
  5. GK22

    How to automate table synchronizing

    look for making a replica on msdn.microsoft.com, this will help you further Gerard
  6. GK22

    allowbyPasskey

    There is a possibility to stop the shift-key code to broke into the database. In what place, and what code exactly is neccesary, and how to make a password to come in by myself, so, don't exclude myself, thnx in Advance, gerard
  7. GK22

    unsplit a database

    you're right, thanx, Gerard
  8. GK22

    unsplit a database

    Is it possible and so how??? to unsplit a database. Though, bring front-end and back-end together again? Thnx in advance, Gerard
  9. GK22

    Database splitting

    That's what I need, Tnx, Gerard
  10. GK22

    Database splitting

    I have the following problem: I split my database, but now I have to make a new table. I put the table into the backend.mdb, refresh the links, but the table never come up in the fore-end.mdb How can I repair this, Thnx in advance Gerard
  11. GK22

    make updates for an application

    thnx I'll try this, can't make a MDE, but seems no problem with .mdb
  12. GK22

    make updates for an application

    I just make an application for a company. They work with it, but I make updates in this time. I split the database with the wizard and so on, but the problem is: I make the updates in the realtime version, how can I Undo the link for only my application, so the other users can work and I can...
  13. GK22

    locking problems with multi users

    Is this possible: There is a form, most of the time I take 1 person from the table and look at him in a form. So it's a filter (1 from all) But sometimes I need to see all records in row, skipping trough the forms with navigation buttons. Then the whole table Person is locked, nobody can do...
  14. GK22

    close a report preview

    I make menubars for the database and ignore the custom menubars from MS Access, but one problem. There are report previews, I want a button on the menubar which enabled when a report preview is active and disabled when it's not. Anybody an idea how to do this? Thanx in advance, Gerard
  15. GK22

    Problems with two people using the same form in Access 2000

    If you mean with 'locked out', the person goes out of the database, it's not correct and you have to set the options to lock edited records. If 'locked out' means only one user can edit a record I think that's correct, it's not great when 2 or more users edit a record at the same time....
  16. GK22

    insert query

    the space was there ;)) don't ask for a values clause, but I do select values (and so on) and now it's ok one thing, there was an error, query fields and targetfields are not in the same order (error 3346) but when I "acdataerrcontinue and so on" it seems good thanx a lot
  17. GK22

    insert query

    No violate data Syntaxis error, but I don't know what's wrong Do you know what syntaxiserror it can be?
  18. GK22

    insert query

    I can't find out what is wrong with the statement: sql = "INSERT INTO OPMERKING_PR([gemaakt door], [datum], [notitie]," & _ "[ leadnummer],[werknummer], [navolging]) SELECT " & _ "str1, str2, str3, str4, str5, str6;" DoCmd.RunSQL sql str'X' compares...
  19. GK22

    Which eventprocedure is needed?

    There is a form with a subform; I need the following procedure: If me.parent.recordsource = "Project" then me.werknummer.value = "" else me.werknummer.value = me.parent.werknummer end if With an Insert query I put the data for the other fields in the subform. at the...
  20. GK22

    resize forms

    Is there a simple way to resize forms from 19" to 17" the resolutions are the same (600x800). Just something like all MS Windows do. I was wondering why this is not automatically in Access but maybe somebody can help me Thanx in advance, Gerard

Part and Inventory Search

Back
Top