Search results for query: *

I have some forms that also includes sub forms. I would like a function in a module that I could call when clicking a button on the forms to ask the user if he wants to save changes or not. I am using the following code, but it does not work. Can anybody help? Public Function...

Looked everywhere and can not seem to find the answer, although I thinks its quite basic. I am wanting to build a car maintenance type database that will help a beginner to do the tasks. There are many tasks, but each task may and usually does involve other tasks. For example: the task(1) to...

I have a lable that appears on a form when the user moves over a button. when the focus is moved off the button to another button the lostfocus event should turn the labels visibility off. This works fine when testing the form, but when is is opened within the main form it does not hide. Any...

I have two tables one of which is a holding table for the other. I am using the code: strsql= "DELETE * from Tablename DoCmd.RunSQL strsql = " INSERT INTO Tablename " _ & "SELECT * FROM HoldingTable" DoCmd.RunSQL The problem is the two tables are different once the Tablename populated from...

If I have a table of part numbers that have been modified such as: 2-1234-001 2-1234-002 2-1234-003 3-444445-009 3-444445-010 How do I turn that into a table that shows: Part Qty 2-1234 3 3-444445 2 I think its a right trim sort of problem. Right(PartNo,Len(PartNo - (Number of digits...

I have a database that runs a long procedure displaying a progress bar whilst it is doing so. The problem is that I can not use the computer for anything while this is happening. Is there any code that can be added to release me to use the operating system fo other things While this is...

I have a couple of spreadsheets with autofilters in various guises (checkboxes, radio buttons, drop down list etc). most of these when apllied show "X of X Records" in the status bar. The one I am working on now only shows "Filter Mode" in the status bar. How can I get the number of filtered...

I have a series checkboxes on a userform,that run autofilters on an Excel speadsheet. if the user closes the form the filters remain on bu when the userform is recalled to change filters, none of the checkboxes are as they were when closed. How can I / what is the best way to store there state???

I have a database which stores part numbers. They are brought in from a spreadsheet and the column is formated as text. Some part numbers are like 7-675F and some are like 1345673. When they are imported, the 1345673 appears like 1.34+E (or similar). How can I get Access to leave them as...

I have a table with lots of parts with different quantities and their costs. I have created a query that extracts rows that have a qty nearest a target qty of 10: SELECT A.PartNo, A.Qty,A.Cost FROM TableName AS A INNER JOIN (SELECT PartNo, Min(Abs(Qty - 10)) AS MinDiff FROM...

Does anybody know how (if its possible) to select a number nearest a target number, from a range of numbers! If I have a range of records: Part Qty A 2 A 10 A 45 A 200 B 3 B 11 B 67 B 999 I want to select the records that have a qty nearest to 10. i.e...