Search results for query: *

Access2000, Customize toolbar Add Menu Add OnAction = UpdTable("tblCustomer") referencing to Function UpdTable(strTable as string) select case strTable case.. .. end select I know how to reference to functions without parameters. But how can I give a parameter in the field OnAction...

I'll try to change my detailheight based on a field (vervallen). It's a boolean, if true then detailheight = 800 else detailheight = 430. What happened? The detailheigth 'walked' one record to late and reset each new page to 430. So it doesn't represent what I want in the right way. Hope...

I made a stand alone application which I have to distribute to several person. Normally I make network applications, so split the database in front_end/back_end and relink the tables with a new update. Now I better like a way to export the tables from the MDE and import after sending a new...

I want to back up my backend database by code: I wrote (with help of tekTips) the code below. But the function failed on the line fso.CopyFile strSource, strDest, True Can the cause be my PROTECTED backend The error is Number 52, Thnx in advance Public Sub BackUp() 'This function backs...

Usage: Access2000 Construction: Form (frmContact) with Cbo (cboWith) The cbo is bounded by a function, the function search for the forms ID: Function HaalCPID() On Error GoTo errHandler HaalCPID = Nz(Forms!contactpersoon!CP_id, 0) 'print without errhandler End Function Problem: I add an RefID in...

Hi all, I have a little problem with printing labels. I customized a label, based on the wizard from Access2000 I need to print 1 label in a time, I write the function for get the label and print the record. The problem is: every time I print a label (we have a real labelprinter (3,0cmx10,5cm)...

I have a little design problem. I have a Ref. from a Ordertable. This Ref. had to be scheduled in a daterange. Daterange can be 31-12-02 till 3-01-02 but also can be 31-12-02, 3-01-02 till 5-01-02, 11-01-02. What's the best method to save this? I tried: tblSchedule: OrderRef (foreign key from...

I build a query in the wizard (access2002) I filled a listbox with the columns of the query I also filled a combobox with the names of the columns, see below: Public Sub VulsorteerLijst() Dim intNumColumns As Integer, intI As Integer Dim strSQL As String, frm As Form Set frm =...

I need to track data with a query from 1-1-02 to 31-12-02, but it must be variable for the years, so next year its 1-1-03 to 31-12-03 What's the easiest way to bound a column on this criteria? Thnx in advance, gerard

I'm using Access2002. I'm making a lot of reports and graphs, some of them drive me crazy as the follow is doing. Maybe someone can help. I need a graph with time (in points of entering) on the x-as and profits on the y-as. The legenda includes a few persons. They all need an own profit-line. I...

I have a form with txtboxes and checkboxes. I want some values be not updateble by some people. ALl people has rights etc. With me.txtbox1.locked = true or false I can handle the checkboxes, but how to handle the checkboxes Any help appreciated, Thnx in advance, gerard

I have 2 queries qryCP: CP_id, naam_contactpersoon gives all customer records qryYear: CP_id, Year gives customerID's with year when they get present CP_id year 1 1999 1 2002 2 2002 QryCP must have one more field: this field contains the match between the queries, if CP_id...

I have the follow code For Each varpositie In cboArtikels.ItemsSelected tempArtikelNaam = cboArtikels.Column(2, varpositie) tempEenheid = cboArtikels.Column(4, varpositie) tempArtID = cboArtikels.Column(0, varpositie) DoCmd.OpenForm "frmPrijsAantal&quot...

I Think the problem of me.pages = 0 becomes while the pages are not formatted at the moment the procedure below is running. My question: which procedure to use to kill this problem thnx in advance, gerard Private Sub Report_Activate() 'function for confirmation, gives as parameter the pages of...

I have a table with several fields. 3 of them are followed_by, written_by, asked_by. All three fields are comboboxes and refered to the same tblUser. Make it a difference to take 3 tblUsers in the grid and build 3 relations between them or take 3 lines from 1 table to the three fields? gerard

I use the rule Docmd.SendObject acSendNoObject for running a daily/weekly automated emailsession. I run it from the AutoForm_Load event with a macro. This give no troubles but what happens exactly with the command? The problem is: sometimes, totally random, when an user start the program at...

Is there anybody who know something about XMLdata connections? I need it to send data from Access2000 to Exact periodically (once a week for example). Any documentation also appreciated. Thnx all for reactions! Gerard

Can I put a password on the backend database? Initutively I think the users can't read from the backend when I do this. Maybe other ways to protect for looking by users in the backend data. thnx in advance, gerard

I open a worddoc with the application.followhyperlink me.docLink structure in Access2000. It works but 2 things irritate me: first> Why becomes the document not the active screen? second> The WebBar comes up irritating in the middle of the screen. How can I solve this 2 'problems'? Thnx in...

I have a form where I doesn't allow edits (by most of the users). But why can't they select a cbo. If this is logic, how can I solve this. It's neccessary for the people to select a value on the cbo and search for the corresponding data in the DB. They doesn't change anything, only read, it's a...