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

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

Is it possible and so how??? to unsplit a database. Though, bring front-end and back-end together again? Thnx in advance, 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

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

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

My english is awful, but I hope I can make myself clear. I have a form, with a subform (this subform has the same view as an Excel spreadsheet, don't know how to name it) How can I make the columns in this subform fixed. So the user can't changes the width and rowheight. Thanx in Advance Gerard

Is it necessary to replicate a database in a multi-users environment? Or is it enough to split in a back-end and front-end database. This is the first time a make a multiuser database, so I hope someone have experience with troubles when you replicate or not. Thanx in Advance Gerard

I have to make an mailingapplication on my database. with a query I select the names. Then i have to transport this to MSword, somebody who have code for me to make this or a place where I can find the code? tnx in advance , gerard

I start the topic again, it's a real problem for me... Choose from a combobox or select all. I make a query, the report is building on this query. The query has a parameter for users. Via a cbo the parameter is filled, but in some situations there must be no filter and all actions from all...

I think it's rather easy, but for me it's a problem at the moment: I have a combobox, with a parameterquery I can select a name from the cbo and all actions for the person who's selected come to the report and will be printable. The problem: I want to make it possible to select nothing, then...

Hi there, I have a little problem: why wouldn't currentproject.connection work when startup.. is used? Error C:\" ".mdb is not a path or directory It works when I doesn't use startup... Anybody who had the same problem? thanx in advance Gerard