Search results

Wow! Did I over look the obvious! A great lesson for both of us in why this forum exists and is so great.

Mmmmm. I would like to see your form and the structure of your table. Is the current password already at max field length? Open your form in design view and (temporarily) clear out the password input masks so you can see what's going on. This error message, it must be coming from an event...

Read up on events and event procedures in Access Help. Your code needs to be split up into event procedures for these text boxes. You may not even need the command button. How does a user get to this form if they have not already entered a valid password once. I like to display the user name...

If I understand, both customers will be selected from the same table? If so, why not use 2 CBOs. The second CBO would list every customer EXCEPT the one chosen in the first. Now you have both customers on the same form and haven't used much space. Create a CBO listing all your customers...

Its been a while since I wrote this. At the time, I used '97. Your word document(s) should be templates with word fields where you want access to insert data. Your code will open the template, fill it in and save it under a defferent name - if you want to save a copy of the completed form...

Did you create your switchboard using the wizzard? Try this. Create a form with just a cmd button. Open your form with the cmd button. If your form works OK this way, check the way your switchboard is opening the form. Seems like I've had a similar problem and it related to the mode my...

(Many) years ago, I did a FoxPro db using bar coded part numbers. We selected PSION hand held units to scan the bar code. The PSION hand held came with necessary software to output the PNs to a text file delimited to our spec (","). From there, it was a snap. Note: We downloaded the data...

Earlier, I posted a question about .CAB files and got an answer. Lately, I've been using Xtractor+ to extract files, but it won't touch .CAB files. Somewhere along the way, I've lost WinZip. I know its a freebee (Probably how I got it to begin with) but I can't find a site where I can...

THis may well be my best A man sits at the counter of a tavern and says "Give me a beer while I read this menu." The bartender puts a glass of beer on the counter and says "That'l be a penny." "Are you kidding? 1 penny?" "Yep" "Wow" "OK, I'm ready to order. I'll have the large steak, salad...

Using Access 2000, Windows 95 (Yes 95), I have downloaded several files samples/templates. I am unable to extract those that are .CAB files. Here's the dumb question. How do I extract these files? Some are access code; some are EXCEL templates.

Try this. (I probably plagerized the same function you are trying to make work.) Me!yourname=CorrectName(LCase(me!yourname)) Public Function CorrectName(ByVal strName As String) As String On Error GoTo err_CorrectName Dim intCounter As Integer strName = StrConv(strName, vbProperCase) 'Look for...

Here's how I do it: Dim dbs as database, rst as recordset set dbs= OpenDatabase(locatetables()) set rst=dbs.openrecordset("tablename",...... ....... Function locatetables() As String locatetables = DLookup("[tablepath]", "tablelocs", "[recno]=1") End Function I have a 1 record table named...

Dumb question. Why not use 2 cascaded CBOs. The first one with a UNIQUE list of last names. The second with a list of (if any) last names matching the one selected from the first. Bound column of second should be SSAN? First name? The notinlist event from either CBO could be serviced by...

Thanks for the help. I tried your idea to no avail. The problem is fixed. The subform is now based on a stored parameter query that uses the main form CBO selection as criteria. The subform immediately displays the selected or newly added record.

On my main form are 2 cascaded CBOs. The "notinlist" event of the 2nd triggers code to add the new record. The subform should then display (via link) the new record for continued editing. The new record is NOT displayed in the subform without first reselecting the added record. If an existing...

You have LIDNo dimensioned as a string and you are trying to perform a math operation on it. I have a customer data table where each record has a unique cust_id (did not want to use an autonumber field). I created a (1 record) table to store the last id# used as an integer and a public...

I have either solved it or worked around the real problem: A: I'm now merging from a table; B: I now open the document using the DOS name extension,".DOT". This works great. I really don't what the real problem was.

Running the code below, I get an error in Word displayed on a blank document. (field calculation error in record 1) If I manually execute the merge in Word from the same query it works fine. Obviously there is something wrong with the code. The code is a slightly modified version of code I...

Thanks for all the tips. The index I'm trying to set was created during the table design (Long ago). The reference to DAO3.6 is verified as already checked in the list. Could I have an unnecessary reference selected that is causing this. I have used this code sequence many times in other...

I have used this code sequence a lot with no problems - until Access2000. Dim dbs as database, rst as recordset set dbs=currentdb set rst=dbs.openrecordset(tablename) rst.index= desired index etc,etc,etc Now, I'm getting error msg saying I can't set that property for the object. Do I need to...