Search results for query: *

Good day: I'm attempting to open a mail-merge Word document from Access switchboard. Can run module from VBA window successfully, but Switchboard will not. Sometime, I get an error that the database is locked by me and wants a user name and password. It defaults the user name to 'Admin'...

I am attempting to build a Report which is a letter to program participatns. In building the address block, I want to trim the [own_city] or city. The data through a query from a linked table. The [own_city] field is 30 characters long and fills unused characters with spaces. The following...

Couldn't find anything in FAQ's or other's posts. I failed to plan ahead and built a form/subform which I would now like to change the Record Source from a table to a query. The forms work just swimmingly while the SubForm keeps the original record source. Existing Condition: Main Form -...

Why will line not work? frm_MailAddr = DLookup("LocAddr", "[dbo_real_master]", "[dbo_real_master]![PIN]= [frm_PINInput]") Attempting to populate fields on a form based on user input of property ID [frm_PINInput]. In this instance the field being populated is frm_MailAdddr. When cursor is...

Utilizing a command button for each record in a continuous form. Want to have command button open another form view complete details for this particular line item based on plat reference. I use this line: DoCmd.OpenForm "frmComplete", , , Forms!frmComplete!_ frmCtxt_PlatRef.Value =...

The linked table ID field of a linked table is text with 26 characters. Eight are the ID number and the remaining blank spaces. How do I remove the spaces? Tried TRIM and LEFT(PIN, 8) in build-table qry w/o success. Your assistance would be greatly appreciated. Thanks, Steven Put the bar...

Having trouble getting text box using short-date format to be identified in VB as an object. Command button uses following code to determine if date field [frmItxt_GISDone] is null. Changed name [Date_Entered] in master table and successive queries and forms as VB Editor's 'List...

Need to update a table onExit from form field. Info fol: Table1: Master. lists all aspects of plat entry & mgmnt. Primary field is PlatRef Table2: Search DB. Contains all possible addresses associated with plat. Primary Field is Auto# Relationship: 1(tbl1)-many(tbl2) using...

Database with two tables. Table1(Tbl1) lists survey plats with primary address. Table2(Tbl2) lists additional addresses. One[Tbl1]-to-many[Tbl2] relationship using PlatID as common field. Query1 builds list from both tables of incomplete plats based on completion date...