Search results

Hopefully this is a simple one. I am running an append query to update my database. I am then requerying it to display the record. On requerying it jumps to the first record in the database. I need it to go to the last record. Can anyone suggest the code to just simply select the last record please?

Hi I have a field that contains receipt numbers, most of which are numeric but a few commence with an alpha character such as "A12345". When the field starts with an alpha character I need to use conditional formatting to highlight the field. Can anyone help me with an expression I can use in...

Hi I have just created a Document Management System in 2007. I have split the DB and am trying to distribute the FE via the Package Solution system in 2007 (first time). The installation went well and all seems to work except for the the lack of a new record input field on most of the forms. ie...

I use the following code in an application I use at work. It is used to query my data for records that fall between the start and finish dates provided in the parameter form "Office Reports". We have just noticed that when doing a monthly report for June that work done on the last day of the...

I have a project with multiple tables with varying data but common to them all is a date field. The date field value can vary but generally is the same. At times i run a process to create a duplicate of the entire record so that I can produce another scenario for the customer. In most cases this...

Hi I've just moved my PC over to Office 2007. I have previously created an application in A2003 that consists of three databases which I move between frequently using command buttons running the following code to close the current one and open the new one:- Private Sub Command14_Click() Dim...

I am developing an Event Management DB for business training courses. I have an attendees table with a link to CompanyNames. I wish to be able to produce an attendees report based on the CompanyName ie all attendees from the selected company. I have done this by using a dropdown of companynames...

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

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

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

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

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

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

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

I open a second database from my first one using the following code Private Sub Command14_Click() On Error GoTo Err_command14_Click DoCmd.Close acForm, "client action amended", acSaveYes Application.FollowHyperlink DLookup("[Link]", "links", "[linkname] = 'DebtProjector'")...

I have a new web project I am working on which I have built using Frontpage 2003. When I preview a page it opens the page in my browser window OK but when I then click on a nav button it opens the new page in another incidence of the Website all other pages then open normally in the second site...

I have developed a Debt Management program for work but I am stuck on a feature that we need to add to it. Basically I have a table which holds "planned future transactions". These are ad hoc transactions that need to be added from time to time to the clients budget. For example the client...

I have a project that is made up of one main database supplying data to two other databases. Normally it works fine. I have installed it on some PC's belonging to our companies agents and in most cases it works fine as well. However, in some cases when one of the smaller databases is opened...

I have a rather large project that has been developed in Access 2000. Generally all my distributions have been to PC's with Access available. However, I do find that there are a few that don't. Obviously this is where Run time would be useful. Having never used it I have a few questions if...