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'...

PHV: Unfortunately this didn't work either. I've never had this problem before. Thanks for you assistance. If you think of anything else, would you mind posting it? Steven Have a great day.

Thanks for the quick response. Not in this case, this field will always have a value. I was wondering if the data from the linked table (which I cannot edit) is a factor. Steven

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...

NEVER MIND! I rebuilt the query from scratch - again. Everything is working just fine. I obviously fat-fingered something or did something incredibly stupid (most likely a healthy combination of both). Sorry to have bothered you. Thanks again, Steven Raise the bar. When you reach it...

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 -...

Thanks... for your time and advise, This did it. Steven Boyer

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...

That did it. I grovel before the masters. Thanks Remou/PHV. You made my weekend. And on that, you all have a greater weekend. Steven Boyer One very satisfied lowly Access programmer.

Found this thread which seems to deal with blank returns. Thread = thread702-785801 Again, I do not have any relationships at this time. Steven

Remou: Actually, frmResultSTtxt_PlatRef [control name from my starting form] displays the desired data. replacing frmResult_STtxt_PlatRef with Me.P results in 'method or data member not found'. The code below appears to be working, but for some reason the return is this complete blank form...

Sorry for the delay in thanking you. My son was sick, and believe it or not, I don't have affordable internet access in my county. First thanks for all your help. I changed frmfrmResult_STtxt_PlatRef [forms control name] to PlatRef [the underlying query field name] and the correct form opens...

Thanks for the quick response. I did as you suggested and got the same result, except this time for 'frmCtxt_PlatRef'

I should have mentioned the "Enter Parameter Value" box was for "ID".

First thank you for taking the time to help. Copy and pasted your advise in and got the "Enter Parameter Value" box. I checked to make sure all my labels and naming were correct. What am I missing? Thanks, Steven An American

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 =...

Sorry, I guess I oversimplified the problem. TRIM and LEFT(ID,8) do not cause any error, but the result still has the spaces. I attemped to APPEND qry and making the destination table ID field text 8 characters long. This resulted in error message which said something like 'type mismatch'...

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...

PHV,AvGuy: Thanks so much. Input your suggestions this morning and everything worked. Best regards, Steven

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...