Search results

Why not just use Application.CurrentProject.Path instead of getting the FullName and then extracting the path. You are adding a couple of unnecessary steps.

Here is a simple method.. Dim loc As String loc = Application.CurrentProject.Path

Just curious.. How much did you pay for .NET? Did you just buy VB .NET, or did you buy the entire Visual Studios .NET? Now that I look at it, I guess you're in New Zealand, so I don't have a clue what your dollars are worth. I'm still interested though.

Oops.. I guess the code break command is SHIFT + Pause Its friday, cut me some slack

You are using Do Whil Not .EOF Loop But... You are never using .MoveNext Also I never see where you use With rst Maybe try this.. With rst Do While Not rst.EOF And Me.OrderID = Forms!frmGoodsReceived!frmGoodsReceivedDetailsSubf orm.Form!OrderID If Not IsNull(ctlQuantity) =...

You can call it a tab, or a subform, or whatever you want. The moral of the story is... If you don't properly relate a new record in the SubDataSheet (or SubTable) then you will not be able to enter new records at all. That is how 1 to 1 works. The rules of referential integrity clearly state...

If you are adding the record to the SubForm, then you will need to tell the Form which element of the MainForm it should link the new SubForm Record to. Confused Yet?! In the On Insert Event of the SubForm, add this bit of code Me.MainID = Forms!MainForm!MainID 'This sets the foreign key...

If you want the combo box to be repopulated on the fly, then put this line in the GotFocus event of the combo box. Me.cboBoxName.Requery This will get the freshest recordset everytime you select the combo box.

If you want to use ****, then you will have to add another form which opens before the protected form. On this new form insert a text box (name it txtPwd) with the Input mask set to Password. Add a button that checks to see if the value entered in the text box is equal to the assigned password...

P.H. I appreciate your poignant reply ... (such tact). :) But... I wasn't talking about trapping the actual error itself. The method I suggested simply traps the fact that there was an error. That way, if it works, then it works. But if not, then the user is prompted with an error message to...

Hey Doc, Some time ago I stumbled upon the method you described above. It has always worked, so I have always used it. The only flaw I found has been in efficiency (or, I should say, lack thereof). Working with unbound forms kind of takes away from one of Access' main functionalities. But...

If you are scared of the programming side, then I would try to create a situation where you need as little code as possible. The way to do this would be to create the Macro to AutoExec On Open, but if it should happen to fail (because the file doesn't exist, or is already open, or whatever)...

I know you said you don't like CODE, but.... This is such an easy fix, I'll just throw it out there and you can do what you want with it. In the On Open Event of the Form, enter this... Dim pwd As String pwd = InputBox("What is the Password?") If pwd = "HocusPocus" Then MsgBox...

Use the Right() Function to extract the far-right character. Like this... Dim lastChar lastChar = Right(YourVariable,1) 'Now convert the lastChar Value to ASCII and check to see what the Ascii Value is. 'If the Ascii value of the extracted character is 65-90 OR 97-122 Then it is an Alpha...

Make a MainForm, "frmOrders" and a SubForm, "frmOrderItems". Include all the fields from your respective tables on these two forms. In the BeforeInsert Event of the SubForm, "frmOrderItems" put this code... Me.Order Number = Forms!frmOrders![Order Number] ... Doing this will insure that...

Why don't you trap the error. Put this in whatever Sub you are taken to when the debug window opens... Private Sub YourSubName On Error GoTo OutLookErr 'code goes here 'and then at the very end of the SAME Sub Procedure add this... OutLookErr_Exit: Exit Sub OutLookErr: If Err.Number =...

Here are two possible problems... 1. I don't think that Dlookup recognizes Table Names that are more than 2 words. If I'm reading your Code right, then you are looking up a value from a table comprised of 3 words, "tbl Day Percent"... Try renaming your table to, tblDayPercent. I think it is a...

Ah pdx_man... Always a pleasure to hear from a fellow Oregonian. Would switching to SQL Server 7 help to make searches faster? Does SQL also have the capability to hold infinitely more records than a simple Access App? How hard is it (in hours please) to make the switch over? I am assuming the...

I am creating a database to log Quality Assurance data. Every unit that is inspected will have around 35 records in the "Master Inspection" table. If there are approx. 100 units inspected per day, that means 3500 new records per day in the table. 5 days a week means roughly 15,000 records a...

Updated Problem I changed my approach a little bit. I embedded the images that I will be using in a pre-existing table in my db. Now if I want to use a picture I just go get it from the table. Here is my new problem... I can get the object (bitmap image) in code, but I am having a hard time...