Microsoft Access / VBA Forum

Hi all, i have an input box that i need the user to put in a password and just wondered if it is possible to just show a * as he types in the letters as per the normal password inputbox ? any help is much appreciated. best regards,

Private Sub PubName_AfterUpdate() Dim sql As String sql = "select PubCode from Publisher where PubName = '" & PubName.Value & "';" Set rst = CurrentDb.OpenRecordset(sql) MsgBox sql If Not rst.BOF Then rst.MoveFirst End If

Great Windows XP tips and tricks http://windowsxpsp2pro.blogspot.com

I have several variabls that are strings. How can I put them on one line. I remember that if you do that, only the last one is the string and the ones before it are not like dim a, b, c as string the c will only be declared correctly.

I have a not in list which is working fine however i want the name passed to the forms customer name field rather than typing it again. Example I type the name in the customer field on form A, Not in list fires, and form B oppens and i have to reenter the name how can i pass the name from A to B here is my not in list. thanks in advance

Most likely a very basic, boring question! My new computer has WinXP (old one Win98). I have installed Office 97 and all is well EXCEPT the Access program. It will not allow me to "Get External Data" from any directory on the machine. The drop down "File Type" window has limited types. There is always a message that I do not have...

I am fairly knowledgable as far as SQL and so forth, but not so well versed in MS Access' version as such. I can't for the life of me work out why this query is returning 'Join Expression Not Supported' It seems like such a straight forward query, can anyone tell me what obvious oversight I'm making? SELECT MYOB_Sales.InvoiceNumber, ...

Hi, Thanks to some great advice I have discovered the joy of subforms - which are perfect for my purpose. However I have some logistical problems. My main form will have textboxes where the user can eneter search terms (eg Name, Address, Postcode etc) - I want them to be able to enter anything from 1 to 10 search term sin these boxes.

I have spent days building a database in access 2003 and the found it needs to run on Access 97, I did the conversion but the form is not opening with an error message "you loaded a form or report that has control or properties that microsoft access does not recognize and will ignore". have tried compacting and repairing and converting to MDE...

Repair registry base, optimize your system, uninstall hidden windows components and get rid of boring errors with powerful tips and tricks. http://windowsxpsp2pro.blogspot.com

Can I solve this problem using Access? If so, will some give this newbie a simple step by step on how to go about it, please....all the way from File/New. In Excel I am using data/filter/autofilter to filter my long list of words, one per row...trouble is in my Excel the columns are only 60,000 rows deep, and my word list is 1,500,000,...

Thank you in advance. This may or may not be the place I need to post this. Is there a way with VBA or Access to build a small application that will extract and install key for Windows, for people that don't have their CD Key or manual? Michael

tblProductions one to many to tblEvents tblEvents contains StartDate I want a report where the data are grouped by tblProductions.ProdID, and sorted by the earliest date in each Production. So this as a query (I've stripped out surplus fields): SELECT qryEvent.EventName, qryProduction.ProdName, qryEvent.ProdID,

I have a multiple-page form for entering info about a project with several sub-forms for sub-projects, notes and tasks. The form and one of the sub-forms each have a combo box to select a record to display, as well as a "last date/time updated" type of field that populates AfterUpdate. What can I do to fix the "Update or CancelUpdate...

Option Compare Database Option Explicit '************ Code Start ********** 'This code was originally written by Dev Ashish. 'It is not to be altered or distributed, 'except as part of an application. 'You are free to use it in any application, 'provided the copyright notice is left unchanged. '

Hello, I'm using Access 2000 and I have a main form with a large subform. When tabbing through the fields on the main from, the screen automatically tabs down, as I like, but when I tab into the subform, the sreen does not automatically scroll vertically as I tab to fields off the screen. Is there a way to fix this so the user does not have...

CustomerTable CustomerTarrifTable TarrifTable WarrantTable *CustomerID CustomerID ProductName *WarrantID BoatType *CustomerTarrifID TarrifRate WarrantDate CustomerName TarrifNo *TarrifNo TarrifNo QuantitySold quantityPurchas CIF CIF Relationships ...

Is anyone using the fHandleFile() from "The Access Web" site in a Terminal Server environment? I just discovered today that it doesn't work for me. Even though I can double-click a PDF file and Acrobat is automatically launched, the function is returning the "File Not Found" error from my app. I was using this instead of FollowHyperlink...

I need to open a Target db and determine if it is in a compiled state and if not to Compile it. The Application.iscompiled status is showing the value for the host mdb - not the Target (when in debug mode) The Target db (ConversionCode.mdb) is being opened sucessfully and I can display the Module names (one again in debug mode) When I try...

- Open Access 2003 - Create new database (2000 or 2002/2003 format) - Create a report and insert a label in its Detail section - Save the report as Report1 - Copy Report1 as Report2 - Open Report1 and insert Report2 in it as subreport - Save Report1 - Create a form and use the wizard to insert a button which can open Report1 for preview -...

I would like to add the xls macros below to the module listed. I am looking for advice as to the best way to go about this. module Public Function clean_pn(pn_in As Variant) As String

Is there a simple way to capatalise the first letter of every word typed into a textbox on a form. Someone told me to use "Proper" but not sure if this is correct or how and where to use it. Please can someone help. Many thanks in advance!

I read in some of the messages that 'autonumber' will reuse the deleted number after compacted. How can we do it in code? Thanks. ming

I have written a query, that works and provides an output. But when I create a report to show this output in a "pretty" format. It comes up with the error "No Current Record". I used the Report wizard and the only changes I made to the report were to change the font and delete a few things. What am I doing wrong. Stephen

Hello I need some help with a SQL query (ASP page accessing Access database) I have a table called 'BookedRooms' which contains the following fields :- Room (text) DateBooked (date) Lesson (numeric from 1 to 9) Staff (text)