Search results

Hi all. Can't seem to find a similar thread although I'm sure there must be one. I have a macro that runs update queries when exiting the database. What I'd like to do is display a message whilst the updates are running. However, I only seem to halt the macro until the user clicks the ok button...

Hi all. I have been tasked with replacing an external database in house and obviously the external database has multilpe tables joined by various id fields. I'm assuming when they created the db they were assigned autonumber qualities etc to create unique numbers. However, I can't replicate...

Can anyone help please? I have used dcount to check the number of records for a query. If there is more than one matching record then a window pops up allowing the user to identify the correct record before proceeding. If there is only one record then the front end form opens with the data...

Can anybody help please. I've set up a database and built a query to export records to excel. However, it appears to truncate the export at 150 rows. I've run the query in access and it brings back 170 rows. Ideas? D

Hi Everyone I need to change a fields properties on a form depending on another fields data. i.e. If a user ticks a Yes/No box saying they've done something they must also complete the date they did it. I can't set the date field in the table to be 'Required' as if ther is no tick then it...

I'm building a macro and part of the macro will be to delete a worksheet. How do I code not to say :'You are about to delete a sheet - proceed' message box. Cheers

Hi all I'm looking to build a report detailing 12 months figures from opening date. I'm comparing them to budgetted figures. My problem is that the budgetted figures are for a full 12 months so I'm comparing 3 months actuals to 12 months budget. What I'd like to do is tell excel how many...

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

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

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

Guys I am building a s/sheet to display data relating to multiple stores. I want the user to pick a store code and all the data to change, which I'm fixing with the offset function. However, I want a picture of the chosen store to display. Is there any way I can get excel to display a picture...

Hi guys I'm trying to create a master s/sheet that will populate data from any number of other s/sheets. I want the user to pick a store number on the master, and excel lookup data from a matching different file. I've tried saying ='C:\My Documents\'&c2&'.xls' but it doesn't work. Any help...

Guys I've searched the database and found similar problems but don't understand the replies (mainly DCount()). I have a control form where a user can search the database by entering information. The form asks them to type some text that will appear in a description field, and match any records...

Guys I've built a database and now need to add more fields. The screen is alreday full so I want to pop-up a new form just to capture these new fields and then go back to the main form. However, I can't get the 2 forms to link together. The new form is opened by a form open button. I...

Guys I'm trying to automate a report in excel. The company like a thin grey row to seperate a range of rows that vary weekly depending on a data file being uploaded. Basically, the grey row needs to move automatically. I've set up formulae to set a cell in column B to say 'Grey' when the bar...

Hi I have a s/sheet for each of 4 Area Managers. They each have upto 13 managers working for them, and they in turn have upto 13 stores they are responsible for. I've set up my lookup's to find all matching stores for one manager and then offset to the next manager when it reaches the end...

I'm trying to link an excel s/sheet into a database, however the link wizard doesn't give me the option of setting field types (text, double etc). It's skipping that screen. I've changed the s/sheet so that all cells are text but on linking the table sets 2 fields to number and I'm losing some...

Help please. I have a text file containing approx. 45000 rows of data. I've created a linked table to upload the file into access keeping the seperator's in place. The file has date and time recorded as e.g. 20050123 for 23/01/2005 and 91527 for 09:15:27. Therefore I'm trying to run a macro on...

Guys I was looking into setting up users on my database to restrict access. However, I've never done this before and I've messed up. I appear to now be the only person who can log onto the database and I have no privileges. How can I log on as the administrator and reset the security. I'm...