Positioning File In One Form From Another Form

Oct 27, 2004

Form: Customers – Uses database Customers indexed on CustName



Form: Contacts – Returns from a list box the name of a valid Customer



Question: Form Customers calls form Contacts. While in the Contacts form, the user can change to a different customer using a list box of all valid customers from which to select. I need to perform (I think) a FindFirst function on Form Customers while in form Contacts, close the Contacts form, and return to the Customer form with it now being positioned to the CustName selected from the list box. All the code I have tried keeps coming back with compile errors. Suggestions with sample code would be greatly appreciated. As usual, I’m sure this is a simple thing to do once I get pointed in the right direction. Thanks in advance.



Ted

View Replies


ADVERTISEMENT

Form Positioning

Feb 8, 2006

I have two forms open in access and everything is fine except the positions of the forms in relation to each other. I want the forms to be side by side when I open them but everytime I adjust them they move the next time. I've checked the proporties and they arn't on auto centre or auto anything can someone help please. Thanks!

View 1 Replies View Related

Forms :: Positioning Form On Screen

Jun 27, 2013

I have a modal, pop-up Form, that I'm using as a dialog box. But, when it opens, I want it positioned on screen in a certain place, but I'm struggling to work out how to do this. What properties do I need to alter/set, to achieve this?

View 7 Replies View Related

Forms :: Storing File Location And Opening File From A Form

Dec 5, 2014

i had a database that allowed me from a form to store a file location for a record on a form, so i any time i could access the record, and then open the file, usually a pdf, it wasnt stored as a hyperlink, but as long text

i made the mistake of not copying the files for safe keeping when i got a permanent position..i am now back self employed, i need to recreate the database.

View 4 Replies View Related

Screen Positioning

Apr 13, 2005

How to I get the screen to show the top of the form?
Solid lines and xs show what is shown on the screen.

This is used for bigger resolutions. I am modifying the layout of the forms depending on the screen resolution.
Also what is the highest resolution anyone has seen an access database running at?

Auto resize and Auto Centre are both already set to no.
Using access 2000. There are no scroll bars on the form.


--------
|.........|
|.........|
|.........|
_______
|xxxxxxx|
|xxxxxxx|
|xxxxxxx|
|xxxxxxx|
|xxxxxxx|
_______
|.........|
|.........|
|.........|
--------

View 2 Replies View Related

Positioning Forms

Jan 30, 2006

Hello All!

You probably think what the hell does the title mean? Well, i cant explain it more better.

What i want to achieve is that i can do a fixed position of a form in Access itself.

Example:

I start my DB ==> startup screen follows
After the startupscreen ==> login screen
After logging in ==> it starts up 2 forms

1 form about the Incidents that are currently running.
1 form is the main menu.

Lets say i want the main menu in the up left corner and that the form of the incidents get right next to it (with some space between it). I hope ive explained this a bit? :)

View 5 Replies View Related

Positioning Forms?

Oct 9, 2005

Hello,

I was just wondering if it was possible to position forms where I want when they are opened.

Thanks

View 3 Replies View Related

Positioning Text Boxes

Jul 10, 2005

Can anyone help please? Is there a way to position a Msg Box. Something like the MoveSize command maybe? I want a Message box to appear at bottom left of my form.

Thanks in anticipation.

DesBlair

View 2 Replies View Related

Modules & VBA :: How To Check Positioning Of Text

Nov 24, 2014

I am required to write a code to check the positioning of a text in a string.

E.g.

"~[Admin]~xxxxxxxxx~ACK~" = Acknowledged
"~xxxxxxxxx~[Admin]~ACK~" = Not Acknowledged
"~xxxxxxxxx~ACK~[Admin]~" = Not Acknowledged

As you can see, as long as the string starts with "~[Admin]~", it is counted as acknowledged. If the "~[Admin]~" appears anywhere else except the start, it is counted as not acknowledged.

I know I'll have to use If-else statements and EOF to cycle through my entire column, but how do I check the positioning of "~[Admin]~"?

Are there wildcard statements that Access VBA can use similar to SQL's "*"?

View 8 Replies View Related

Forms :: Displaying X Combo Boxes And Positioning Them

Mar 30, 2014

I'm making a database of (electronics) chips in Access 2010. These have varying amounts of pins - 6, 8, 14, 16, 18, 20, 24, 28, 32 or 40.

On a datasheet, they are drawn as per the following image:

[URL]....

As you can see, the pin numbers run down the left hand side, then up the right hand side.

I have a table, tblPinouts. This has a text field called PinoutName and 40 number fields - Pin01 etc. It also has another number field - PinCount.

On a form - frmPinouts - the pin fields will be entered via combo boxes, which get their data from a table - tlkpSignals. However, I want the form to be visual, as per the picture. I've managed to draw a chip using boxes (as this seems preferable to using pictures), like this:

However, I want to adjust the 'drawing' accordingly for each chip. This means doing several things:
Extending the main rectangle downwards
Ensuring there are x small rectangles around the main rectangle at set points
Ensuring there are x labels inside the main rectangle at set points
Ensuring there are x combo boxes around the 'drawing' at set points

How can I ensure that only the first x combo boxes and small rectangles (x=PinCount) are present when a record is loaded, and that they are arranged correctly?

View 6 Replies View Related

Need File Tree In A Form.

Jul 14, 2005

I have a form in which I want to place a box that has a specific file directory displayed at all times for the user to open files from.

Please help!! Really new at this.

:)

View 5 Replies View Related

Sub Form And Excel File

Jun 16, 2006

Hi

I have a form which has a sub form in it
I created a button which I want when clicked on to export what is in the sub form to an excel file ... Can someone tell me how please

View 2 Replies View Related

Displaying PDF File In A Form?

Oct 29, 2012

In my table of assembly numbers where each assembly number has a set of work instructions as a pdf file. I'm wondering if it is possible to display the pdf file as an object within a form..?

I know its possible to open this document as a hyperlink but I want it to be embedded within the form.

View 1 Replies View Related

Open A Word File From A Form

Jun 5, 2005

Hi all
I need to run a certain file from the form
I create a button as follows
Select in the categories "Applications" then select "Run Ms Word"
I have tested it and it open Word but not even a blank page
I then open the code as seen below and want to insert the filename but do not know where. Can someone please help me?

Private Sub Command35_Click()
On Error GoTo Err_Command35_Click

Dim oApp As Object

Set oApp = CreateObject("Word.Application")
oApp.Visible = True

Exit_Command35_Click:
Exit Sub

Err_Command35_Click:
MsgBox Err.Description
Resume Exit_Command35_Click

End Sub

The file is - D:PanelbeatersPb Manual.doc

View 2 Replies View Related

How To Put Text File In Access DB Form

Apr 12, 2007

I have created a Word Doc which is a help file for the new users. I tried to paste it in a new form but it takes only a few lines whereas the Word Doc has five pages. Is there a way to embed/link/paste this help file to my Access DB? Grateful for help.

View 1 Replies View Related

How Do I Use A Form Field To Open A File On My PC ?

Jun 2, 2005

I am trying to write a little database to view my MP3 collection (as you do when youre bored...)

I have a field that shows the full path to my MP3's

e.g "D:My MP3'siTunes MusicBob DylanDesire3 Mozambique.mp3"

I want to be able to click on the file link to launch the file in my MP3 player - I have tried changing the field type to "hyperlink", but that still doesn't work...

Any help greatly appreciated.

View 2 Replies View Related

How Do I Point Form To Table In Another *.mdb File?

Jun 27, 2006

I have separated my application logic (forms, VBA code, queries) from my data and am unable to open my form. The form is in file DbAppl.mdb and the table is in file DbData.mdb. Any ideas? Thanks.

View 4 Replies View Related

Link MS Project File To Form

Aug 14, 2006

http://www.access-programmers.co.uk/...ad.php?t=97787

I am attempting to add a command button on a form that will allow user to browse files, then select a MS Project file to import, then have it linked to the current record (by a hyperlink or icon of some sort) so that clicking on it will open that MS Project file.

I found the above thread and have imported the modules and the fFindOpenImportFile in order to test in my database. I have made only slight alterations to the code, as I am still a novice w/ VB, but may not have done so correctly. In the Private Sub bImport_Click, I inserted 'tbFile' where sample "C:WindowsWin.ini" had previously been, so that it will import the file already selected from the bBrowse_Click. (If there is a cleaner/better way to do this, I would appreciate any help.)

Here is an exceprt from the code:
Private Sub bImport_Click()
On Error GoTo Err_bImport_Click

Me.tbHidden.SetFocus

If IsNull(tbFile) Or tbFile = "" Then
MsgBox "Please browse and select a valid file to import.", vbCritical, "Invalid File"
Else
If Dir(tbFile) <> "" Then
CurrentDb().Execute "DELETE * FROM tImport"
'FileCopy "C:WINNTWin.ini", "C:WINNTWin.txt"
DoCmd.TransferText acImportDelim, , "tImport", "tbFile", False
MsgBox "Your file has been imported into the Database."
Else
MsgBox "Your computer does not have a C:WindowsWin.ini file so the import example will not work.", vbInformation
End If
End If

Exit_bImport_Click:
Exit Sub

Err_bImport_Click:
MsgBox Err.Number & " - " & Err.Description
Resume Exit_bImport_Click

End Sub

The imported form works great for 'Browse' or 'Open', but when I try 'Import', I get the following error:

2391- Field 'F1' doesn't exist in destination table 'tImport'

I even went back to the sample database and tested the form within the sample, using "win.ini" file and get the same error????:eek:

Of course, when I try it with an actual *.mpp file, I get this error:

31519- You cannot import this file.

...which leads me to believe that even if I fix the first error, I might be on the totally wrong path b/c it's an *.mpp file???:confused:

Any help would be greatly appreciated.

Thanks in advance for any help!

View 5 Replies View Related

Display Database File Name On Form

Sep 4, 2006

I wish to display my database file name on a form.
Can someone please advise me.

Thanks
Hugh

View 3 Replies View Related

How Do I Point Form To Table In Another *.mdb File?

Jun 27, 2006

My .mdb file was getting too large (500+ mb) and taking a long time to compress, so I separated my application logic (forms, modules, queries) from my data (tables) and now I'm unable to open my form because it can't find the table it's based on. The form is in file DbAppl.mdb and the table is in file DbData.mdb. I thought I could point my form in the one mdb file to the table in another by putting ME.RecordSource = C:xxxDbData.mdb in the Open Form event, but I can't seem to get it working.

View 1 Replies View Related

Modules & VBA :: File Hyperlink In Form?

Jan 6, 2014

Im developing a database for work, I would like to provide a link on a form to run an external program. The form is call frmProfile. The table is called tblProfile and the hyperlink field is called link.

I would like a diaglog box to appear where the user can browse for the file and select it. Ive found various scripts but with my vb skills being very basic its no wonder im getting no joy.

I should add... each record has its own associated file. Its cctv footage which runs from the cctv systems own proprietary software. So its an individual filefor each record not just a program.

View 1 Replies View Related

Modules & VBA :: How To Export Form To PDF File

Apr 7, 2014

In access i want to create a button that can export a form to a .pdf file i know this is possible true VBA, and i tried to google but all those vba codes do not work.

View 3 Replies View Related

Modules & VBA :: Opening PDF File In Form?

Jul 22, 2015

I've got a table with field define as hyperlink which stores link to a external pdf.

Then i create a form including this field and add a unbound field which has got intermet browser format (as a type).

What code I have to put in onclick event in a hyperlink property sheet to open PDF inside the form?

View 1 Replies View Related

Forms :: Preview PDF File Within A Form

May 19, 2014

Is there anyway to preview a pdf file within a form ?

the sample db is what im looking for , but in the preview window have it show what file to show, pending on what is selected.

View 3 Replies View Related

Open PDF File From Access Form

Sep 8, 2012

I have a lot of pdf file that we save every day and name them like this 8012012,8022012, that are 2 digits day, 2 digits month and four digits of years no slashes. The fields are txt fields that we receive from banks. After processing their data, the upper management wants me to open those pdf files form access . I have created form named frmOpenPdf, placed text box named txtName and placed also command button named cmdOpen . I research code over internet and here is below, but it doesn't work;

Dim avCodeFile As CAcroAVDoc
Dim MYSRTING As String
MYSTRING = txtName.Value
Set Acroapp = CreateObject("AcroExch.App")
Acroapp.Show
Set avCodeFile = CreateObject("AcroExch.AVDoc") 'This is the code file
avCodeFile.Open "C:Documents and SettingsDesktopETFPdfFilesMYSTRING.pdf",

I would like to have like this : an user types 08012012 and the code execute to open file names 0802012 in command button .

View 1 Replies View Related

How To Display Attachment File Name In A Form

Jun 22, 2014

How to display attachment file name in a form? I have attachment field in my form and attached to 2 or more images. I put "Attachment.File Name" field under my attachment images. "Attachment.File Name" field displays the name of the first image of my attachment images like a "title". Whenever I click forward or backward arrow to see my attachment images, I want "Attachment.File Name" field also shows the correct name of the attachment image.

View 6 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved