Search results

I have been trying to get my crosstab working and have run into a spot of bother. I have followed the process detailed in SOLUTIONS.mdb to the letter but keep getting thrown out with the rejection Run-Time Error 2448 You can't assign a value to this object" at the line highlighted in the code...

Hi I have created a combo box with some underlying code to filter the results on my form by a specific field. In other words, I select a field from the list and the form is set to sort ascending by this selection. Well, that's what I would lilke it to do anyway. To do this I have been looking...

Hi all I have been using some code from this site to filter my forms and subforms via a selection of combo boxes. However, when I try to filter by either date or callid, I get runtime error 2001 and the debugger drops in at the first forms!filter line. This seems to work perfectly well for the...

Hi all I have created an email link for Groupwise in order to be able to send queries from my database to the relevant people. I would like to be able to open up my Groupwise address book and select the people to send to but I cannot find a way of pulling the information back from the address...

Hi all I am trying to filter one of my tables from code to match up with a reference on my opening form. This reference is a building code. Basically I want to select the building I work in and have the tables filter for those specific results. I then need to use this reference in any new...

Hi all I need to create a piece of VBA to stop data being entered into a particular cell unless certain other ones are blank. THis is is ensure that no data is entered for an overall category if anything has been entered for it's subcode. I.e. If cells E4 to E7 contain data then cell E3 cannot...

Hi I have created an call logging system for my company and have integrated the basGWdemo for Access 97 module into it. I have given it the ability to add multiple names for sending emails which is all well and good. However, at present, the mail is sent out without Groupwise actually being...

I have been asked to take a database created last year and re-design it to make it more user-friendly. Not a problem, I thought when asked but I am running into a little problem...(the database designer) In my opinion, to make a system more user-friendly there is a necessity to access the code...

My company has finally bitten the bullet and decided to upgrade their systems before their software goes out of date for user support. However, this means that they are about tio upgrade from Office 97 to Office 2003 running on a Windows 2000 operating system. How much of an issue am I going to...

Good Afternoon All I have finally managed to create a report that builds on the fly to correlate all my data into a summary. However, for some reason, the detail section of my report only throws one line instead of moving on through the recordset. Also, (probably due to the above problem) the...

Does anyone have any idea how to sync two forms so that I can create one record in a table from the pair of them. I have a form which is so big that I have had to place a continuation to a new form on it. However, when I move to the new form, the data is placed into a new record instead of...

I am creating a form based directly on some paperwork which needs to be logged electronically, Unfortunately this extends well over the 55" that Access allows for a form. Not a problem I thought, just create a second form and place a continuation button on the first...Obviously not. When I place...

Hi I am trying to build a crosstab report which generates the columns from a query on the fly. THe reason for this is to record any issues we have on each day so for example We first call the report on the 1st of March and we had Issue----------------Total Issues-----01/03/06 Printer...

Hi I am trying to pass some details from a combo box into an email I am creating as part of a call logging system for my company. I want to pass the text relating to the combo and not the actual bound column so I thought that an IF statement would be the way to go. I have used message boxes...

Hi I am trying to pass some details from a combo box into an email I am creating as part of a call logging system for my company. I want to pass the text relating to the combo and not the actual bound column so I thought that an IF statement would be the way to go. I have used message boxes...

Hi, Can someone please have a look at the below code and see where I'm going wrong. The code works and I have tested it with message boxes to prove that but the new password isn't being returned to the table. Option Compare Database Option Explicit Dim pwcount As Integer Private Sub...

Morning guys and gals I am trying to create a sceduling calendar for my department which displays given events day by day. I have created this using subforms for each day and a combo box to select the month. For display purposes it works fine but I am having a little difficulty with the...

My company are looking to move over to Office 2003 and Access 2003 within the next few months and I was wondering how much of an issue this will be regarding my Access 97 databases that I have been creating for them. Will it be a case of making sure everything is in VB so that there can't be...

Firstly I'd just like to say thanls to Tim for his help in getting me this far. Your coding for multi-select listboxes was great. However, once again I am having a few problems getting any further. The problem now isn't transferring data from one list box to the other but is the fact that my...

I am currently creating a database to link together a maintenance system and a conditional reporting system and I’ve run into a little problem. I am trying to create a form for assigning skills to a given contractor (contractor selected via a combo box (cboContractor)) by transferring selected...