Search results

I have a DB designed in A2k originally which uses a tabbed control as the main input form. in A2K the tabbed form was greyish as were the tabs and buttons. THis all worked fine. I recently converted to A2003, using windows theme which looke quite good except that the tabbed form turned a shaded...

Hi Minkey, that did it. Thanks very much I would never have worked that one out.

Just revisiting this problem as it has not gone away. To try and clarify it. When I navigate to my website the home page opens as expected. When I then click on a nav button I can see that the new page has opened as it appears on the task bar at the bottom of the screen. However, the home...

Thanks Bob will do. Bye

Hi Bob Thanks for the reply. Just to clarify, this problem is not limited to just one of my databases it occurs in all access databases and the same Db's work OK on other pc's. It's just mine and that is why I thought it is most likely to be a problem with my Office install. I will be trying...

I have a program which I designed and has been running fine for quite a while now. I have just returned from leave and find that when I access the code and start to amend it i get a runtime error:- Program: C:\Program Files\Microsoft Office\Office11\MSACCESS.exe this application has requested...

G'day All. We have created an Custom ActiveX Library (DLL) in VB6 and wish to call functions in this library from VBA. This works perfectly on my machine but when distributing the application (MDB) to other machines we get an 429 Cannot create ActiveX component error. I have traced this...

Hi Lisa Have you tried setting up an input mask for the date field. Go into the table design view for the required table, select the date field and use the Input Mask wizard to set it up.

Hi NiNiel Thanks for the response. I maintain the list of hyperlinks in a table. But they are activated via a form. Cheers Peter

In an access table I have hyperlinks to various documents mainly word docs. I have recently added a Publisher doc and when I H/L to it it will open the application but not the doco. Obviously Publisher behaves differently than Word in this regard. I do need the link to open the doc. Is there...

Thanks Pat I'll redo the form and put the calcs in the query as you suggest. Thanks for that. Peter

I have a sub form on a tabbed control. In the subform I have some calculated controls and I make them recalc when ever data in other fields change bu entering a recalc cmd in the update event of the required fields. That is all fine but the problem is that the forms focus moves to the first...

Thanks GTH & CEH for your suggestions. I will give them a go and let you know the result.

I have a need to enter dates so that they always appear as the first of the month. These dates are used in vlookup functions in Excel and need to be constantly recorded as eg 1 Nov 06. Currently I have to rely on notes and training to make sure users only insert the date in this way. What I...

Hi Al I think that may be the problem. The field I am using in the criteria is not actually a combo box but the data that is in it originally came from one. so I will need to revisit the structure to see how I can get the same info but using a different method. Cheers Peter

Hi Al Not having a lot of luck here. I think I have something wrong with the data. I set up the textbox as you suggested and the correct number appears. I then add the reference to the query as a criteria and get no records. If I reference another field from the same form using the same syntax...

Thanks RG and GTH for your reply. Hey RG glad to here from you again. I'm still plugging away at this project. It's pretty much done and I'm now going back over it and making refinements to address user requests but overall it works very well ( thanks to your help along the way). I'll apply what...

I am trying to limit the number of records displaying in a subform [amendedLoans] by selecting only those records that have the same ClientID as the mainform [Customers] and the same loan number as the subforms parent form [ClientAccounts loan changes].[loanno]. I have no difficulty selecting...

Thank you both for your replies. The problem actually lay with where I was trying to run the command from. The subform was on a tabbed control which I neglected to mention. I was trying to run the requery on the subforms Events and tried every possiblity without any luck. In the process of...

I have used the following command on a command button to requery my subform and it works as I planned. However, if I copy it to say,the OpenEvent for the same form, nothing happens. I'm obviously missing something here. [Forms]![Customers]![mysubform].Form.Requery All help appreciated thanks