Search results

None are missing. I've tried to uncheck / recheck them, worked for all exept for the first two, Visual Basis for Applications and Microsoft Access 9.0 Object Library, in which I think the relevant reference is. It displays a message that it can't change it because it's used. Come to think about...

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

Nevertheless, I think a requery of the subform should do the trick. Call it from the same code as the add new is performed, or on the current event. so something like: me.subform.requery HTH M.

Do you mean at which form is used to open automatically. It's called SwitchBoard. (Not a switchboard created by Access, but a normal form called switchboard by me) This doesn't open either automatically or by double clicking on it.

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

For the subform u can probably use Link child/master property and enter the desired field.

U can create a query with criteria pointing to a form's textbox. Click on build expression editor en navigate to the forms textbox (probably) HTH M.

Assume level 3 sum textbox is called L3Text then put in level 2 footer something like =Sum[Level2] + [L3Text] HTH M.

When you create a textbox you also get a label. To erase the label do this. Click on the textbox the click on the label, it's now selected seperately. Press the delete button. Should do it. M

Found it, In the original report I grouped on other field, and didn't remove them, so it wanted to sort on these (invisible) fields. M

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

I think I tried something like that, but couldn't get it to work. Solved it by using the criterium 'Like [Parameters].[EmployeeCode] In the Parameter table I enter a * Now I'm working on a way to enter a between criterium, so I can enter three criteria < date > date between dates I have two...

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

And what about changing it back to a date so something like date = function(weeknr,weekday)

I don't think it is possible to link 1 form to more than one table. however U could use subforms, and link each subform to a different table. HTH. M.

Hmmm, I could try that. I don't have a dedicated test machine, but something should be possible. I'll post my findings when I have them. In the meantime, thanks for your effort to try and solve this issue. M.

Yes I have Microsoft ADO Ext. for DDL and Security selected. And the others you mentioned. Tried it several times with new db's. Even un and re installed office. No luck. I also found out that something is wrong with the Microsoft Jet 4.0 provider When I try to open a table using this...

Thanks, First worked great, forgot the hh.exe bit. The second one works also, but displays a message the the to be opened file can be harmful. The docmd.setwarning false command is of no influence So I stick with the first one M.

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.