Search results

did you try double quotes? "Abacavir (Ziagen)" should work ok

Hi, The be must be shared anyway (or the folder it resides in) or the client couldnt see it, what is it you are trying to do? a frind of mine at work was doing something to do with having a "dynamic" be to a dbase, and I seem to recall he was doing this via ip rather than unc name, what is it...

Thanks, Looks like I was editing at the same time as you posted, sory to have wasted your time :( CALV

Thanks for the reply, I tried a compact/repair- no joy I then tried making a form with the same recordsource as the problem form, but with a single button (no code- just to see if it displayed) and a textbox bound to a field from the query. now heres where it gets odder! the query takes one of...

ok this is getting mad :( I changed the code slightly for when the button is clicked to display the form to: DoCmd.OpenForm "form name", acNormal, , , , acWindowNormal this now opens the form, BUT the form is EMPTY!! its just a totally empty form, however when I slightly resize the form...

Hi all, I have a sort of menu form which, when initially opened, opens several other forms but hidden, this works for most of the forms, but I recently added a new form to the dbase and it doesnt work! heres what I have in the on load of the menu form: DoCmd.OpenForm "first form", , , , ...

This has happened to me before, when a reference is missing, did you try vba.trim instead of just trim

Hi, sorry for butting in on your post but I think this is related, and I've kept meaning to ask! What is the difference in me.textbox1 = "hello" or and textbox1.value = "hello" I've always used textbox1.whatever as against me.textbox CALV

Thanks, I tried that but I get a 1 displayed in every one :( Heres what I put Private Sub Form_Current() Dim frm As Form Call CurrentFormRecord(Forms!frmview_only) Debug.Print lngrecordnum End Sub Sub CurrentFormRecord(frm As Form) Dim strtest As Long strtest = frm.CurrentRecord...

Thanks, I read the help, and it gave me the snippet of code, but how do I implement that in my db? where do I call it from? TIA CALV

Hi, and thanks for the quick reply, I did display it but I'd also like it in the top right of the continuous form CALV

Hi all, As part of my ongoing project, I now have a form whos data source is a query which is a sort of lookup. The form is continuous, and all is working well, BUT, I'd like a txt box on each record displaying the curent record number, I searched high and low to try and find this, but to no...

Hi all, I created a small dbase today for a friend at work, nothing special, just a sort of calender/planner, I created it in access 2000, put it on his system - office xp, and got the typical screen about converting it, but then an error occurs, it wants to make a backup, so I make one, then...

Interesing topic which applies to my current db also, though I have the advantage of being network admin :) But reading through these posts, sprang to mind, I once had a small db whose back end was on a "common" network share, all the company used this drive for "junk", the folder which...

Thanks! dcx693, yes because the network is SLOW, so what I have done is have the user select between which dates they want furthur info, then run a query to get this info, then using the above code, transfer it from the query to a local table, I have no clue as to what better method to use, but...

Hi all, I've been securing my dbase by disabling shift/f11 etc which all works fine, only now my "admin mode" wont work! the code I use to disable toolbars etc is : Dim i As Integer For i = 1 To CommandBars.Count CommandBars(i).Enabled = False Next i but when I do the OPPOSITE, from the click...

Hi all, Im currently trying to speed up my db, and Im stuck on a bit! What I have is a table with 14 fields, on a network share, the table has a lot of records, and what Im trying to do, is drag over to a local table, via a query, the records I currently need, the query runs and shows the...

Ok, lets try this! We'll get there one way or another! I tried opening it in access97 and got the same probs.The attatched file has a txt file and a codeless form, hope it works! CALV

Thanks for the reply, it sort of makes sense, only I have no clue on how to implement it!, you mention pulling all the data to the front end, then running an append query, wont this slow things down more if I drag the whole table accross the netwrok everytime details are entered? Thanks CALV

WOW! Thats cool!