Search results

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

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

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

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

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

Hi all, I created an application that I was using at my work. Now other people would like to use it. I would like to have a client-server setup for my DB. Can I do this by just putting the application on a server? Can a single application handle multiple users? What if I open a recordset and...

Hi, I would like to send an Email via a button on my form. I found a nice piece of code on this forum but.... when I try to compile the source it produces an error: "..... datatype is not defined" This is de code I used: Private Sub cmdSendEmail_Click() On Error GoTo Error_Handler Dim...

Hi, I was wondering if it is possible to create a mailinglist (comma separated List) from a query result. I think it can be done with VBA but also here I don't know how I can do this. Is there someone who can help me with these two problems Regards

Additem on ListBox causes a compile error Hi, I am create a project on Windows XP in which I use Listboxes. The rowsource of the Listboxes are "value list". example: If txtAddPlb_tabVestiging.Value <> "" Then Form_VestigingenForm.lstPlbEdit_tabVestiging.RowSourceType = "Value List"...

Helo, I wont to send a Word document to email recipients which are located in my access database. Is there a simple way to do this? Without using VBA I mean? I am using the Office 2000 packet. I am sure there has to be a way to do this with one of the programms out of the office packet but...