Search results for query: *

Can someone tell me why my code (below) works when in accdb format but as soon as I convert to accde format I the exact same code doesn't work! Function AddResults() Dim LoserScoreSlot, WinSlot, LoseSlot, LoserName As String LoserScoreSlot =...

Not have any prior knowledge of server hardware/storage I thought it was a simple matter of just adding new drive to my DL380 to add extra space. I currently have 4 x HP 146GB 10K SAS 2.5 DP HDD's (assuming RAID5?) and want to add a 300GB SAS drive into it to increase storage space. Being a...

Looking for a quick and simple VB solution to retrieve the filepath and filename (i.e. "c:\backend\mydb4.mdb") of any given 'linked table'. [yinyang] Shann

What is the easiest way to convert a series of unrelated table data to one single text file...whilst having the ability to transfer data back to their respective tables? Is my only option a VB one? as I realise converting one table at a time (and importing back) will achieve the result I'm...

What is the easiest way to convert a series of unrelated table data to one single text file...whilst having the ability to transfer data back to their respective tables? Is my only option a VB one? as I realise converting one table at a time (and importing back) will achieve the result I'm...

Just as I can check a date string value to see whether its a valid date (using IsDate)...can I do the same thing for a time string - maybe someone out there has a custom IsTime function they could share with me? Cheers [yinyang] Shann

How can one "ensure" that a database has all applicable libraries available? I've noticed that some installs of Access (2000 or greater) do not include libraries that I've referenced when designing my database. Is it a matter of informing users that they have to install the latest service...

I've created a database which runs well under Access 2000. Now when running the same database under Access XP it crashes when I go to perform a particular action; "It crashes when I go to click a button on a form", heres the code for that button: Private Sub Transfer_Click() On Error Resume...

I'm sure this can be done just don't know how. On a form I have 4 combo boxes: [Player1] [Player2] [Player3] [Player4] And 4 text boxes: [Player1 Details] [Player2 Details] [Player3 Details] [Player4 Details] For each combo box I have an Update event which does a Dlookup which sends its...

What is the best method of passing the value of the activecontrol on a form to a text box? Lets say I have 20 text boxes with random text values. I also have a text box which changes to the value of the Active Control. I can do this in vb but am having to repeat the process for each of the 20...

From time to time my mouse cursor becomes invisible when hovering over the taskbar + start menu items. I know its its there though because I can still choose items etc...just can't see the cursor so I play a bit of a guessing game as to where I think the cursor is currently situated. I use...

I have a table with multiple text fields. Each one is set to 50 text string characters long (the default). The weird thing is that with some (not all) of the text fields no matter how long the actual text values are, 'Access' decides to add space characters to the end. For instance... Lets...

My database (W2K) has an autoload form, when I go to load it it doesn't load the data connected to it or run any of the vb code I have in the 'on open' event. I get around this by clicking design and THEN re-opening the form - not an ideal situation. I recently upated my office package using...

I would like to produce a query that takes columns of data and sorta crosstabs it. For example, I have a table with the following column headings: TREENUM, HT01avg, HT01stdev, HT01min, HT01max, WD01avg, WD0102stdev, WD02min, WD02max (note that HT01=Height and WD01=Width) I would like an SQL...

I have some VB code that populates a listbox with my tables...I would like to add a column to the listbox so it shows what .mdb file each table is linked to (or not). Example: "TableName1", "Linked to C:\DB1.mdb" "TableName2", "Linked to C:\DB1.mdb&quot...

I know there are various solutions to this problem...I was just wondering what would be the best....heres the scenario: ONE frontend with all forms and queries setup. Multiple backends with exactly the same table structure. I have set up a form in the frontend that lists (within a listbox)...

I have installed Redhat 9 with a Samba Domain...its been going very well. However, I neglected to setup RAID1 (mirror drive) at installation. My 2nd HDD has been set up as a standard partition.... Am I able to setup Raid without having to reformat my entire system? Thanks For The Help...

I have RH9 with a samba domain and have successfully added clients to it. All I want now is to share a COMMON ADDRESS BOOK and was wondering what domain I would use in slapd.conf (dc=mydomain,dc=com)? My RH9 machine netbios name is: "Centaur" (163.252.105.2) My Samba Workgroup/Domain...

Linux Newbie Here... I've been going round in circles and it seems there is no quick solution to sharing a "common address book" between a RH9 distro running a Samba Domain with several WinXP Pro clients using MS Outlook 2K as there mail app. Just when I think I have the right...

I have successfully set up a Samba Domain/Workgroup where I have copied all my MS Access backends into. All is fine, but now only one person can use any particular database at a time...this is not the result I was after. Not sure if this is a Samba issue (could be an Access issue, or even...