Search:

Hi,

I have a curious problem that I'm not too sure how to solve.
I have a database that was built in Access 2000. This database is used where I work and up to now has had no issues.
However...

Hi,
I'd like to create a short questionaire in Microsoft Outlook where the user receives it via email and then uses a form?? to fill in the questions with exact responses.
Once completed I'd like...

Hi,
Can anyone guide me to a recommended software package which will allow me to digitally remaster some old audio files which are quite grainy due to the age of the recording. They have the normal...

Hi,
I have recently bought a secondhand laptop after complaints from my wife over being hidden away surfing the net for hours on end.
Turning the Dell D600 on I was greeted by a screen displaying a...

Of course!!!! Something about the wood for the trees comes to mind! <img src=/S/stupidme.gif border=0 alt=stupidme width=30 height=30>
If I needed to line up some further text with the line in the...

Hi,
I think I already know the answer, but is there a way to bracket two lines, or multiple lines together with a bracket, namely } without using a text box to enlarge } and insert it at the end of...

Thats the problem I'm getting. Presumably there is no way around it, currently I have disabled the calendar facility on this field as the archive facility is more important.

FrmDirectionsSub is the sub form on FrmMain, and the field I was referring to is DateSent which has the onclick event as previously described.
For size purposes I have had to delete the actual...

Hi,

Thanks for that, it work a treat and does do precisely what I was after.

Regarding the previous issue, is there any reason I can only get it to open if I remove this:
...

Sorry, I'm still having a problem getting the combobox to work. I've amended the QryMainDef to reflect your suggestion. I've also set the RowSource to the same query, still no luck.
The archive on...

Hi,
I think I've managed to condense the database down to what you need and I've attached a fresh copy.
I couldn't get the coding to work on the DateServed field, to alter the Archive status.
I...

Hi,

I have a specific sequence for opening the attached database.
When the database is initially entered the user is asked to select their role from FrmStartup and dependant upon the role...

Thanks for that, I'll try it when I get home.
Would I be right in thinking that this error would have been caused by me not entering a user name in full? What will the above actually do?

Hi,

I had a problem last week were my O/S (Vista) simply disappeared! I have run hard drive diagnostics on the drive with no errors.
So I have reinstalled Windows Vista Ultimate, however during...

Will this approach allow for various editing rights and locking fields? This is specified in the original coding.

Hi,
I have attached a database that I'm having problems with. I'm trying to adapt an existing database into performing a simliar task.
The purpose of the database is to record dates that papers...

Hi,
I have searched the forums for a suitable answer, but I'm still not too sure what to do, and I haven't dipped into Access for a while so I'm a bit rusty.

I have a Table, TblDirections with...

Hi,
Is it possible to link a DVI-I connector on a graphics card, to a standard CRT monitor that doesn't have those connections. Currently I have an adapter, but when I connect it the picture on the...

So at the moment I have:

strSQL = "UPDATE [TblMain] SET Archive=False WHERE URN=" & Chr(34) & Me.CboReactivate & Chr(34) I've added this as URN is a text field, is this correct? ...

Not too sure where I would start with that one, presumably I would store the value from CboReactivate and use this value in CmdReactivate to set the value of Archive relating to that record (from...

Thinking about this, if you have a combobox with the details of all archived cases, presumably I could actually control the archive status from the Main form negating the need for...

Hi,

Is it possible to alter the behaviour of a combo box, or rather set an event as below to it?
I have a database that has live records and archived records. The main form is filtered to show...

<P ID="edit" class=small>(Edited by armitageshanks on 13-Nov-07 09:00. )</P>When the user enters data onto the excel spreadsheet and clicks on CmdCalculate it returns a Grand Total value in column P....

Hi,
I have an excel workbook that is effectively performs calculations.
There is a control on it called cmdCalc with the code below this post.

Basically it returns a Grand Total that I need to...

So if I change the Index in TblDefendants, DefendantID to Yes (No Duplicates) will this solve the problem?
Or will I need an adjoining table between TblMain and TblDefendant with something like...