Search results

So i've been trying all sorts of things today with still no success. It appears as though the view is displaying at the form view size rather than the screen size. Any other suggestions? Also I dont know a lot about VBA let alone how to use or place it, so if it requires such please bear with me.

Here is the code for the event procedures for "On Open". Private Sub Form_Open(Cancel As Integer) 'Me.myclosebutton.Left = (Me.Width * 0.9) - (Me.myclosebutton.Width / 2) Me.Command32.Left = Me.WindowWidth - Me.Command32.Width End Sub Is this whate you are speaking of? When I open the...

I checked the test.zip file G37Sam reposted and it appears to be exactly what I origionally posted. I did in fact check the left and top properties of the button and it comes up where I want it in design view but still comes up in the center on the form view. Should I make the design view larger...

I have a field on a form which the user currently has to manually type in the file path to a specific picture on a local drive. After the file path is entered, the path is linked and the picture is shown in an image box. I did this because I didnt want to bog the database down with attached...

I just found this post and realize its several years old, however hopefully someone can help me. I clicked on the link and got this message. No Thread specified. If you followed a valid link, please notify the administrator I presume based on the answer that this is what Adam was looking for...

Thank you much, there is always a first time for something and here is my first time.

I'm afraid i'm not sure what you are talking about. I've got a sample db with the form in it which i'd like to post but I dont see an add option other than the link and image. Do you know how I can add this sample to a post?

I am relatively new at building access databases and thus far i've been prety successfull specifically with the help of this site. I am not at all familiar with coding or vba so if what i'm trying to do requires it please bear with me. In any case, I am trying to create a macro to...

Thanks for the help. My ultimate intention is to have the button show up on the far right side of the form header. I do not want it centered. I'll try the code you provided and change the numbers until it works out. What information in the code would I need to change if any: ie: I presume...

I have a form which has an exit button which I want located on the top right portion of the form header. When in design view on the form itself, the button is located where I want it; however when I look at the form in form view, I find the button is shifted to the left or in the center of the...

I was looking into this a bit further waiting for a response and started playing with the individual query relationship, a little bit of this and a little bit of that then tadaa, it works. Just shortly after finding the result I was looking for, I received a notification on my smart phone that...

I am trying to create a query which contains fields from multiple tables. I've managed to create the query as I have with any other query i've built; however when I add the field from a secondary table, when I run the query, the results comes back missing a good majority of data. Can anyone help...

Pat, First off thank you in advance for taking the interest in giving me the information you have thus far. Unfortunately I am not at all familiar with of understand the process of programming VBA code, is that something you might be able to help me with?

What/where is the output method options located?

Now awake, i realize my response probably didnt make much since. I wrote it with just shy of 3 hours of sleep after a 12 hour shift. I have a button with an embeded macro which prompts for the specific report to save or email. I have one button for each option when i click on the appropriate...

Saving and emailing by pushing a button which has the save or email procedure via the button operation.

I had this problem when i first started testing and printing my reports. This is a very tedius process to fix. Go to the report that prints before the blank sheet and view it in print preview. Check for any right indent fields extending beyond the page break. In my situation, the "blank"...

I am trying to build a "year book" style report of pictures of employees. I am trying to create a report which shows an employees name directly under an "image" box, theoretically the picture would be of the named employee. I have a report started; however the problem is my data is showing in...

I am working on a db that has options of saving and emailing a report. Most of the reports are specific to a general tenant space. What I would like to know, is there a way to save or email a report by default to title itself the chosen "tenant" name rather than the "query/report" name, the item...

Disregard, i read further and found that i was not reading enough and figured it out based on what you had posted. Thanks for the great information.