Search results

I have a new database that is based on a tried and tested formula of mine, with the exception of one or two new bits. Everything seemed to be going well, until a couple of days ago (ironically, when this site was down). The problem was this: When I input data into the database manually...

I have a macro that imports data from an excel file called DataTest. The data is imported into a temporary table, then split into seperate tables and all records deleted from the temporary table. Is there a way to delete the original records from the excel spreadsheet - leaving it ready to...

I am having a problem with the following piece of code, but only incertain circumstances. It gives an error message when the Surname starts O'xxxx (i.e. O'Halloran, O'Connor etc) Code = Left(LeadTable![Surname], 6) & Right(LeadTable![HomeTel], 4) Set CustTable =...

I have a form that does all sorts of stuff, including adding the contents of one field (Amount) to another. If there is no data in the field, I need a message box to pop up and ask for the amount. I can't for the life of me think of how to do it. Anyone help?? Please!!

I have a report which is like an application form, which is based on a query. The query shows all records in tblCustomer and only records in tblCustPrevAddress where joined files are equal. Problem is when a customer has more than one previous address I get two reports - one with the first...

I have the following code in my report, and it works great (thanks to help from this forum). Private Sub GroupFooter0_Format(Cancel As Integer, FormatCount As Integer) If Me![StatusCode] = 0 Then Me.Box53.BackColor = RGB(0, 0, 0) ElseIf Me.StatusCode = 1 Then Me.Box53.BackColor = RGB(210, 170...

Can someone please tell me where I can find a list of all the colour codes. i.e. Black = 0 Red = 255 etc....

I have a database nearing completion that is to be distributed to local operatives in the field. The company want to ensure that: 1 nobody is doing any work that they should not be doing 2 the operative in the field does not decide to up-sticks and start up in business on his own. The...

OK here is the scenario. I have been developing a database for a company over the last few months, and (with a little help from members of these forums) it is coming on nicely. I have already agreed a price for doing the work, but now a new partner of the company wants to get involved. He is of...

I have a A97 database that I have been using without problem for years. I have recently put A2002 on my machine as well as A97. The front end of the database has just been amended slightly (in A97) and distributed to all users. Now they all come up with an error message like "Cannot find...

I have searched these forums but still haven't found an answer that really gets me going. I now have two clients who want a kind of diary/scheduler of appointments on their application. The latest client runs a sunbed salon, and wants a form showing which of his six beds are booked and for...

I know that this has been broached before, but..... some of the responses are a bit technical for me. I have been told that I need to upgrade from A97 to A2002. The computers that we have all came with Office97 already installed, so I have no idea about licenses etc... etc. Bearing in mind...

I have a form which holds all of our client records in alphabetical order. I am trying to reduce the use of mouse finding it much quicker to use keyboard shortcuts. I have a shortcut to launch the find record pop up, but when I have entered the customer name, I want the pop up box to...

I have done a database for some friends of mine who run a small website in the UK. Rather than have someone receiving information and having to feed the information into the database, they want people to be able to access it via the site. Now I am a total ignoramus when it comes to the...

....snagging this piece of code for me, and telling me why I get the message "The OpenForm action was cancelled" ____________________________________________________ Private Sub AddRecord_Click() On Error GoTo Err_AddRecord_Click Dim MyDb As DATABASE Dim CustTable As Recordset Dim...

...... but is there a way of automatically and deliberately corrupting a database, or preventing it from working. Why???? I want to send a copy of a database to a potential client, but I am obviously concerned that once he has it, he won't need to buy it. I have created a form that loads on...

It has been a couple of months since I last compacted the database, so I thought I should do it again. However, I get the following message: Record(s) can't be read: no permission on c:\Application I have checked the permissions, and I cannot find anything that as Admin I cannot read. What...

OK – now I really AM struggling to get my head round this one. Scenario I am developing a database for a Finance Company/brokers. They have a group of lenders, all of which offer different schemes. Each scheme (and each lender) have different criteria for approval, and different interest...

I have a database that records the hours that someone is logged on to it. Problem is...... for the database to record the time that the User logs off, it requires the User to click on the Exit button. I have removed the control boxes from the form, but there is still a control box in the Access...

Some of you may have heard of some software called ACT!. It synchronises with MS Outlook. Is there a way of having appointments recorded in an Access database synchronise with Outlook? It would be useful because of some of the features of Outlook. (One would have thought that this was...