Search results

Thank you FLM! This one is cool! I noticed it doesn't work wile debugging but ... A very nice one to have!!! AND Thank you WayneRyan! You made a very nice example! This I can defenitly use! Cheers Jayke

I guess your right! I already save a line number with each product when I save the tender. But still... it is a hell of a job. But do you know how I can get the name of a control in which my cursor is set? If this is possible I will go for that "Hell".. :rolleyes: Cheers

Hi, I am creating an appication in which someone can make tenders. Each tender can be saved and edited. On my form I have put 15 textBoxes and listboxes. Each control represents a line. The customer can fill in or choose a product or service on each line. Here is my case: A customer creates a...

One addition: I currently use this code Set objWord = GetObject(s_templateDocNaam, "Word.Document") ' Make Word visible. objWord.Application.Visible = True strConnect = "DSN=MS Access Database;DBQ=" & CurrentDb.Name & "FIL=MS Access;"...

Hi, I am currently working on an application which merges addresses from an acces addressbook to a Word template. So far I succeeded. BUT, the customer would like to have a preview document (concept), which can be reviewed and edited by other people and eventually be made final! So all merge...

Cannot find the reference Hi Jules48, I have the same problem. I looked for the reference comctl32.ocx but I couldn't find it. Is it listed under another name? Regards Jayke

Yes, I am using it now. And it works ok! Thanks you all!

Sorry for the delay! Persons do not have to belong to a company but it can be. I have a one-to-many relationship between these tables. Regards

I understand, but I did do normalisation. In my database a company can have one or more persons (employees). So I have a one-on-many relationship between tblCompanies and tblPersons. So I think I did this like I should do it. I think not splitting them up would be a bad normalisation. What...

HI, I tried the union and it worked. I learned something new here today!!! :) but what I can't do is an ORDER BY on the two different selects. What I also want is that I can double click on one of the items in the list en then open the related form. Ex. When double clicking on a person in...

Hi, I am currently working on an adressbook which contains persons and companies. I have two tables tblCompanies and tblPersons. Both of them contain some simular data like name, phone, E-mail, ... I would like to merge these two tables in one List Box. So the List Box would contain both the...

Thanks! | can see the light again! :) You have been very helpfull! Regards.

Hi, I am creating some table for a database I want to use. I had the following tables: [Organisation] orgOrganisationID (primary key) orgName orgPostalcode orgStreet orgCity orgCountry [Contacts] coContactID (primary key) coSurename coFirstname coFysicPostalcode...

Hi, I have read some posts about splitting the DB and I am going to use this for my Database. Currently I open a recordset when the Database is opened and I close the recordset when I shut down the form/Database. Now my question: - Is this smart? Can it corrupt my database when more users open...

Hi, I have created a search form where people can search for company names. It works fine but I try to search for a company like l'amour then it goes wrong. I get following error Run-time error '3075': Syntax error (missing operator) in query expression 'vstNaam LIKE '*l'amour*';'. I see that...

Thx all for your responses. I will try this later at home! About the name of the forms. Well "Form_VestigingenForm" is the name of the form and now you mention it, it is not a nice naming convention. I will remove the prefix. thx

Hi Sean, Thanx for your reply. I emmediatly tried it but I got following error: ----- Error 2467 during execution: The expression points to an object that is closed or that doesn't exist ----- Because I got the error in dutch I transelated it. Maybe it looks a little wierd! I used the...

Hi there, Is it possible to check with VBA whether a Form is open/loaded? I am currently writing some VBA code behind a form (Form_1). In that code I want to check whether another form (Form_2) is open or loaded. Can somebody help me? I think it is something stupid but I just cannot find it. thx

Pat, Thank you! With the description you gave I can certenly move on!!! Cheers!

Hi, Thanks for your responses. So splitting the DB is the best thing to do. Ok, I have something about it and indeed it doesn't sound that spactacular. ;) But what about the .mde and .mdb files? Each users should have such a file to have access to the DB? Can someone tell me more about it...