Search results for query: *

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

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...

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

thnx maquis, looks fine, I will try Gerard

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

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

you're right, thanx, Gerard

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

That's what I need, Tnx, Gerard

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

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

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...

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...

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

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....

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

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

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...

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...

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