Search results

hi all I have a form that has invisible fields. Depending on the navigation to the form, those fields are turned on/off using the visible command. However, the tab order on the form always takes the user to the first field visible on the form. How can I tell access to default me a specific...

Actually - forget that, this will bring every record back. Need to do something I learned from this forum. The [Please enter author] question has to be copied and placed in a blank column at then end of your query in the field name box (top box) and so does the [Please enter second]. Then...

No worries - I've only been doing it myself for about a year and this forum keeps amazing me. The query needs to have every field in your table available to query - this will then make them available to view on your form. in the query - I'm guesssing you want them to search either or and and...

Build a query using all filtered fields and base the form on the query.

I've looked at numerous threads on this site and still can't get a dcount to work. I want the database to check if there is a valid reference number entered before opening a form. There is a table called 'staff' with a 'payroll number' field in it. This table contains all staff. I then want...

I have a database where I'm allowing a user to update a record in a table using a form. I want the user to be able to search by name to find therir unique reference number if they don't know it already. I've built a query and based a form on the query so the user gets a personal profile for...

Actually - if I take out the 'if target.address' bit just leaving InsertPicture, every time I click in a cell it puts 2 copies of the picture in the worksheet. So somehow, it is exit sub even if the cell I'm changing is m1. Any ideas?

It's something I do that works for me but is probably very long winded. Stores that have been open less than one year only have one years data to present, those open between 1 and 2 years have 2 years data and those over 2 we report on the first 3 years. Therefore I've got 3 different w/sheets...

Sorry for the delay in replying buddy. Got this now: Option Explicit Private Sub InsertPicture() Dim pct As Picture Dim iLeft, iTop, iWidth, iHeight With ActiveCell iLeft = .Left iTop = .Top iWidth = .Width iHeight = .Height End With Range("h7").Select Set pct =...

Nope - don't understand the printing the right number of stores code you posted earlier. I have 3 templete s/sheets to print - each store is only going to appear in one of the three templates, but move depending on time open. i.e. all stores will print in template 1 until they become 2 years...

Ok - so now I've got: Sub InsertPicture() Dim pct As Picture Dim iLeft, iTop, iWidth, iHeight With ActiveCell iLeft = .Left iTop = .Top iWidth = .Width iHeight = .Height End With Set pct = ActiveSheet.Pictures.Insert(Range("aa1").Value) pct.Left =...

Blimey - cheers buddy. Will have a lok if I get time. Think I'm going to end up creating 32 different sheets for this report. Darren

Ok -got it now cheers. So what do I put in it. range (b3).change run macro? Cheers D

Will have a look and try and work it out. Cheers buddy. Do you have any ideas how to get an Indirect formula to populate the data without having the file open? My Indirect is pulling data in from various other files into one summary s/sheet. Cheers

Wass? You lost me with the word Array buddy. Any chance of some dummy code for me to play with. Cheers

How do I get to see the change event option? Right click on the name of the sheet only gives me view code. Cheers

Ok buddy - code works great if I run the macro. I have 2 questions: 1) Is there any way of stipluating the size of the image because it fills the screen when it opens, even though the original image is tiny. 2) Can I get the code to run automatically whenever the user changes the dropdown...

Ok buddy - code works great if I run the macro. I have 2 questions: 1) Is there any way of stipluating the size of the image because it fills the screen when it opens, even though the original image is tiny. 2) Can I get the code to run automatically whenever the user changes the dropdown...

Ok buddy - code works great if I run the macro. I have 2 questions: 1) Is there any way of stipluating the size of the image because it fills the screen when it opens, even though the original image is tiny. 2) Can I get the code to run automatically whenever the user changes the dropdown...

Guys I have a s/sheet detailing financial P&L information for stores which the user can choose using a dropdown. However, we want a print button which will print every store regardless of the one chosen. My first idea is to record a macro where I manually change each store and print the...