Hi Jan, Do you want to find records in the form's recordsource or some where else? How many records in the source of your search, hundreds, thousands,...
I have read what I can find but it is still not clear, I have two fields in a table called FirstName, LastName however the user put both in the FirstName...
Richard- You should set the Required property of the LastName field to Yes to prevent this in the future. What is in the FirstName field? John Smith John Q....
You are correct in that I should have set the required property, this is the first time I have had a problem with this, will consider in the future "If it can...
Richard- Then you can try an update query like this - do it on a COPY of the table first! UPDATE MyTable SET FirstName = Left([FirstName], Instr([FirstName], "...
I have a form with a textbox, I am parsing information and want to change commas to a CRLF so instead of the data in a text box looking like this Terence...
Hi everbody... how to connect Direct Ms Access File .mdb, Data pages, Projet, to web server or FTP or HTTp server or How to make Ms Access File as web based...
Terence- Are you doing this in code or in an expression in a query or text box? If in code: Me.txtBox = Me.Name_field & vbCRLF & Me.Addr_field & vbCRLF &...
You can't. You can use an .mdb file as the database storage, but you must write code in an Active Server Page or PHP or Perl to use the data in a web page. ...
I've recently started an online information site for USA cities, using vBulletin software. vBulletin is PHP based, and I'd like to use MS Access 2003 to store...
Hi, John is right. The best way to get information from Access on to a web page is by using your web development software to develop your web pages and...
Pat- One caveat about DAP - they're very difficult to deploy on the web. They work OK on an Intranet as long as everyone has a copy of Office. John Viescas,...
Hi John, Thanks for the reminder. I hope you are having a great New Year! The HTML Access produces often require a lot of work to make it more presentable for...
Hi, I wish I knew how to use PHP, but I am working with ASP.Net and that is enough for my pea brain. If you do not get a response here you might try a web...
I have a form that is opening up but it just will allow me to enter new records. I don't have the ability to see previous records. It's actually a header form...
Hi Joe, set the form DataEntry property to No if it is yes, you can ONLY enter records ... Warm Regards, Crystal Microsoft MVP remote programming and...
John, I think I understand and see what -1 and +1 are doing but will the -1 alwyas give you the end of the first word or is it something else? Is InStr short...
Richard- By way of explanation, the Instr function returns the offset of the first occurence of the search string. Let's say FirstName contains: John Smith In...
How would I write the VB that will look at table _PASSHEADER and return me only records where ACTIVE = YES Here's a link to an image of what I'm trying to do. ...
How would I write the VB that will look at table _PASSHEADER and return me only records where ACTIVE = YES Here's a link to an image of what I'm trying to do. ...
Joe- DoCmd.OpenForm rs!Argument, WhereCondition:="Active = True" John Viescas, author Microsoft Office Access 2007 Inside Out Building Microsoft Access...
hI Joe, You almost already wrote it yourself! DoCmd.OpenForm "YourFormName", WhereCondition:="ACTIVE = YES" This only works on the main form however and not...
Joe Here is the DAO code. If you are using Acc 2000 or Acc XP you'll have to add the DAO library to your references. Public Sub TestStuff() Dim db As...
Oops! I didn't scroll up high enough in my list of emails. I didn't see the whole thread. Regards, Bill From: MS_Access_Professionals@yahoogroups.com ...
I have a command button that upon clicking it from a menu opens a form that is populated by a query requiring a parameter input. When I click the command...
Patrick The second form is opening before the calling form closes. That is to be expected, but you can hide the current form. Your code would look something...
Having problems with message search?
Fill out this form to ensure your group is one of the first to be migrated to the new message search system.
