Search results

Just a quick response, as I have to shoot . . . 1.Can you check that the field [MEDRECNO] is used on the new form you open. 2. Can you check that the Control Name on your subform is "MEDRECNO" (will be the ControlSource too anyway). If so, try this: strLinkCriteria = "[MEDRECNO]= '" &...

This will clear the listbox, and force the user to choose again: Me.lstAssistRequests.value = ""

What errors messages are you getting? What about Using the menu option Debug\Compile (your module name)

If you SQL is the same every time (i.e. it is set by the properties of the listbox), then all you need is the: Me.lstAssistRequests.Requery. Does this not work?

Look at DateDiff and DateAdd. For instance, to how many months difference in 12 months time: date() - is todays date. datediff("m",date(),Dateadd("m",12,date()) )

look at "between #date1# and #date2#"

Hi, I know (and use) the code for using a DSN already setup on a user's PC. But, does anyone know how do it it without the DSN alredy setup in VBA to an Oracle db? Many thanks.

Just a quick thought, to elimate the easiest option . . . It could be a problem with the server db. Can you open the table on the server db? Possibly it has become corrupted. I would repair the server db and try again.

Are you saying that by replacing your object names that the above code will not work??

In your Report code, copy and past this in where necessary. Create a label on the Page Footer too called lblFooterIndex The 3 dim statements below stick at the top of your report just after Option Compare Database: Dim mstrFrom As String Dim mstrTo_new As String Dim mstrTo As String Private...

Try this little beauty . . . . Be careful with the Delete button as the record pointer will point at the first record in the subform. Perhaps stick a "Are you certain?" prompt for the user when deleting. Private Sub cmdOpen_Click() dim stDocName, stLinkCriteria as String strDocName =...

Put a break point in the first line of the function/sub routine. Then in the immediate Window type in the name of that sub, press RETURN et voila! You might have to pass in some data if the function accepts paramters.

Why not update a text or ini file.

Plus, if the database becomes corrupt you may lose data. Thus splitting the db it is allows you to refresh corrupted front-ends without touching the back-ends. I created a batch file that downloads the front-end to the users C Drive. See the batch file and version file attached. 1. Put your db...

Hi guys, I've had this problem before. The debug window will open and stop at a line of code even though it has no breakpoint. Any suggestions please. Thanks.

First, go to Macros. Create a Macro called AutoKeys. (Access will automaically check this whenever you use Shortcut Keys) Open the macro in design view. Choose from the menu View\"Macro Name". The "Macro Name" column is where you specify the shortcut keys. In Action, well that's what will...

Does this not work?: DataGridName.AddItem data1 & vbTab & data2 & vbTab & data3 . . . the vbTab will add the data to the next column without having to name the columns directly. To setup the grid, here's some nifty code: 'Add columns With DataGridName...

Look at MkDir

Setup up the recordsource in subform to sortby WtEntryID Desc??

Look at InStr