Search results

also if I copy and paste the filepath in the "link" field where me.link is in the code it works fine too. something wrong with the declaration of the variable I think

its the full filepath. infact if I copy whats in that field and paste it where strFilePath is it opens the file no problem but if I leave it as is I get the security pop up and the 490 error. the filepath listed in the warning is exactly what the file path is supposed to be so im not sure why im...

I would like to open a PDF document using a button control on a form to a file path listed in a field on the form (Me.Link). I am trying to use the followHyperlink code but I keep getting the runtime 490 error. This is the code im using: Dim strFilePath As String strFilePath = Me.Link...

I would like to open a Word document using a button control on a form to a file path listed in a field on the form. I use the following code when I want to open a single specific document... Dim wdApp As Word.Application, wdDoc As Word.Document On Error Resume Next Set wdApp = GetObject(...

sorry, again, I was not specific enough. This is for a subform datasheet on an order form and not an entire table so the data wont ALWAYS be the same as the information on the form will change based when its opened and the primary key of the parent form (which is the order number). all I want to...

I have a form that is a datasheet. it contains multiple records. One of the fields in that datasheet is a combo box. I would like to make it so when I select a value from the combo box it changes all the values of the other records in that column/field to what was chosen from that combo box. is...

I hear what your saying and initially I was going to build it that way but sometimes we transfer items to the trucks that arnt on sales orders like consumables for instance that we don't put on sales orders but in thinking of this I may modify they way the sales orders work to incorporate what...

okay I will restart including specifics, its possible that im going about this totally wrong. The database I built is an inventory/order tracking database. in this case The first form im working with is a "sales Order" form, the parent part of this form contains information on the customer...

Sorry MarkK but im a total noob when it comes to this. Im still a bit confused about what you are suggesting. Currently I have a button on Form A that opens Form B and passes the Parent values of the form to Form B using Openargs. From what I understand from your posts to pass the subform data...

im not exactly sure what you mean. the key/fk link to the form I want the data to transfer is to different tables so im not sure how that would work, could you expand on what your describing and how I would requery data from a different table than the one the form is linked to?

I know how to use openargs to pass values between forms but im not sure how to go about passing all the values from one subform to another. To be specific I have an order form (frmCustomerOrders) that has fields like CustomerName, EmployeeName, OrderDate and so forth, the subform...

I have lots of combo boxes in my forms that are mostly limit to list as I want the people entering the data to actually add the full details of a client or supplier or whatever instead of just typing the information in over and over again. if the person/client/supplier is not in that list I have...

thanks got it to work

quick question I have a form with a subform. I would like a control in my parent form to uncheck a checkbox control in my subform when that field value is deleted . I can get that to work if there is only one record in my subform but it doesn't uncheck the rest. how to I reference all the...

Thanks for the replies. I will keep that in mind if I run into this problem again but after mucking around for awhile I figured out a way. I went to design view and added an unbound textbox, switched back to datasheet view, moved some columns around then added a value to the unbound column...

this is driving me bonkers, I have a datasheet form that is based off a query and is not editable due to expressions in the query. you might be asking why do you have a form that is not editable? well that's because the query im using has expression names that wouldn't be useful to another user...

I am trying to add a save/close button to a form that will only close if certain conditions are met and if they arnt then display a message box. I got the basics on how to save and close the form, do a simple if statement and display the message I want but the problem im running into is my...

yes it does, thank you :) now if you wouldnt mind could you briefly explain what the Nz bit means and why I need it? im glad that this works and will definetly use it but if im going to use it I would like to know what it means, for future use. I tried to google it but I know absolutely...

Im am new to access and querys so im probably doing something simple wrong but here is my problem I have a query that sums up the amount of products that are allocated by customer Orders and another that sums up the Products that are allocated by pending Transfers to our trucks, so what im...

hello I just started working with access about a month ago and have been dabbling in access since as my boss is looking to get me more involved in the office side of things and could use some help managing our databases. I have been pouring over some access material and learning a lot...