Search results

Hi there, I'm having a problem joining a workgroup on a users machine. I tried joining a workgroup that I created and that's sitting on a server (Secure.mdw) and then I tried joining the System.mdw that's on the user's harddrive. With both attempts I'm getting an error message saying...

When I created the New Workgroup I named it Secure.mdw and placed it on the network drive. I tried rejoining the System.mdw and was able to get in w/o being asked for password info. I rejoined the Secure.mdw and I'm still getting in on the users machine when opening the database through...

Thanks Ade. I made sure all the Admin rights and User's Group rights were taken away and I'm still having the problem. Any idea why I'm not able to enter the database through Windows Explorer on the computer where I created the database and I'm able to from other users computers? This is...

Hi, I've run through all the steps in securing my database on the network, however there seems to be a problem. On the computer where I created the workgroup I'm asked for a username and password when going through the shortcut and when I try to open the Database through Windows explorer I get...

Wayne, I'm putting the memo fields in a new table because I need to view all the comments in a report listed out like this: * comment * comment * comment * comment etc. If you have any other suggestions on how I should go about this please let me know. I'm not sure why you don't like my...

Wayne, It is a memo field in the new table. Double checked that. So I'm not actually trying to combine the memo fields into 1 large memo field. I just want to add all the memo fields to the new table with one memo field. So If I have 1 record in the first table I should end up with 6...

Wayne, Sorry if I wasn't clear. I have 6 memo fields in one table: x1comments x2comments x3comments x4comments x5comments x6comments I'm trying to cosolidate this into one memo field in a new table. Taking all the x1comments and adding them to the new table then taking all the x2comments and...

Hi there, I have a table with 6 memo fields and I want to add all the memo field data to a different table with 1 memo field. So I have some vb code that pulls out memo field1 data then adds to the new table then pulls out memo field2 data and adds to the new table etc. For some reason the...

Try putting that code on the "On Exit" event of each textbox if you want the message to pop up during the navigation.

Works Great!! Thanks for your help Matt. That was killing me.

Matt, Thanks for the quick response. The zip field is text. That works for the 9 digit zipcodes, but now the zipcodes that only have 5 digits are showing: "22102-2102" when it should show "22102" It's adding the last 4 digits of the zip to the end. Any other thoughts? Thanks, Full Williams

Hi, I'm trying to display addresses in a mail label report like this: John Doe 1234 S. Street San Francisco, CA 22102 My problem is that some addresses within my table have 9 digits and some have only 5. The addresses with 5 digits display correct while the address with 9 digits display as...

Hi there, Does anyone know if it's possible to call a Function from an ASP page? Any help would be appreciated. Thanks, Full Williams

If your application isn't too big you can send it to me at robertgrabowski@hotmail.com and I'll take a look.

Did you try putting say "P*" when prompted for [Enter Applicants Last Name]? This should bring up all last name that start with P.

Try putting the "*" inside the "[]" at the end of the name.

Yes that's what I'm thinking. You might try using Like [Enter Applicants Last Name]* Also, try looking up "Like" in help. Let me know if you get it.

Put "Like [Enter Applicant's Last Name:]" in your queries criteria. The sql will look something like this: SELECT tblApplicants.LName FROM tblApplicants WHERE (((tblApplicants.LName) Like [Enter Applicant's Last Name:])); Hope that helps.

Try using Like <text> * in your criteria.

Newman, Thanks for all your help. Not sure if it has to do with your version not. As it turns out they don't want the MidInitial in the Name now just Salutation, First Last Name which I can handle. Go figure. Thanks for your help though. Full Williams