Search results

Hi, :confused: I've got a strange problem and can't solve it. I distribute a database among multiple systems with multiple setups. Work fine normally, but now on one machine (XP) one form with a unbound textbox with the default value set to "Date()" without the quotations marks, doesn't work...

I've got a problem opening one of the forms. It's the startup form, but it doesn't show anymore. Also the code behind the form isn't accessible anymore. I get an error saying I cancelled the previous action. Also trying to open it manually doesn't work. All other form work perfectly. This...

Hi, My database is suffering from speed problems due a FE-BE where the BE is on the server. It's a bussiness database where we keep record on the hours worked. I keep all the work data in the BE. For this specific problem I need to use three tables - Hours, There are about 20.000 records...

Hi, I've created a report with a wizzard which was grouped on projectlevel. The details displayed every entry for all employees. In another report I want to summarize these lists. So I created a copy of the first report. I added a group footer for on the employee field. Structure: - Report...

Hi, I want to create a parameter query for which the criteria are defined on the fly. To do this I've created a table called Parameters with several fields and only one record, and I use this one for all the queries. Then, depending on which query I want to use I fill the table with the correct...

Hi, I've got a custom help file (.chm). I want to open it on the click of a commandbutton. I've tried the shell command, but it doesn't work. If I open it directly from the explorer then it works perfectly, just can't do it in code. Any help? M.

Hi, I'm using a piece of code I found at mvps. And uptil now it has worked perfectly. It resets the autonumber of a table to a specified number. Function ChangeSeed(strTbl As String, strCol As String, LngSeed As Long) As Boolean 'You must pass the following variables to this function. 'strTbl...

Hi I'm struggling to make a overview report. Let me first explain what I'm trying to do. I'm making a project managment database for my company. Each project consists of 3 types of costs which are put in different tables all with an identifier field which is the projectcode. So I have four...

Hi, I'm going to design a access database with which I want to conduct a survey. The survey is about cataloging some product which are available in the market. To do this cataloging I've stated four subcategories. Now I have to give a score to every possible combination of values from those...

Hi, I want to draw a triangle on a report. I know it's possible to draw rectangle and cirles but not any other form. Is it also possible to rotate an object for an arbitrary number of degrees. Thanx in advance

Hi, I want to make a query that searches multiple tables for a specific string, f.i. Like '*an*' The tables have to be seperated because they contain different data. It's a database where I keep my collected info on a project. I have a table called "Literatuur" and a table called "Informatie"...

Hi, I want to export a recordset which I created at runtime to a Excel table. I tried to use docmd.outputto .. statement but I can't get it to work. Dim rst as Recordset Set rst = CurrentDB.OpenRecordset("SELECT * FROM strTable WHERE [Name] Like '*', dbOpenSnapshot) DoCmd.OutputTo...