Search results

Can I reopen this thread because, so far as I can tell, I'm doing as instructed but I'm still not getting the subform to requery, refresh, repaint or anything. I have a search form with a combobox to select a Field, a textbox to enter a search string into and a button to click on, which fires...

boblarson, I understand your point, but it isn't quite that simple - it never is! The developer recreated Query Analyzer within the front end, so that empowered users could create their own queries. However, those queries aren't preserved across database upgrades. I could go back to the...

First, I apologise if this is in the wrong forum - please feel free to move it. I think though that it's more VBA related than Query. My client has a split database on which development of the front end is ongoing but the database is in use. On upgrading the front end, it's necessary to open...

Bump - just in case this got buried in a flurry of new topics

Well, I did say that I was missing the obvious - I have just enough information or knowledge to be lethal! So, if I move the formulae that populate those unbound text boxes to the VBA module behind each form, which event would be best as the trigger to update them as the Member field is changed...

David Eager, is that at form level or text box level? gemma-the-husky, if I understand correctly then, these are populated at the time of loading the form, with the data from the first query. How do I then get them to regenerate (trying to avoid access terminology) each time the query changes...

Fixing that has highlighted another problem and, as it's still form-related and probably equally blindingly obvious to somebody that knows, I'll keep it in the same thread. On my subforms I have unbound text boxes where users can enter new data for the database and which are populated using...

Missinglinq's solution solved my problem, for which thank you, but the other information is also mighty useful, so thank you boblarson as well.

I'm building a GUI to an existing database, starting with a form that contains various subforms, each of which shows categories of data from the database. Each subform is linked to the master form correctly using parent-children relationships and, once a record is selected, these work. However...

Thanks to copious searching of this forum, and the posted efforts of ghudson and others, I've been able to cobble together a backup routine that is called on closing the database and creates a hierarchy of folders based on the current date. I post the current code for your use, as this question...

An alternative is to share the workbook. Then you can edit it regardless of who else is in it. Beware though, certain functionality is disabled in a shared workbook and you need to carefully review the options in order to ensure that you don't automatically overkey changes made by others when...

Try going back to first principals - Average = Sum / Count. Therefore, instead of using =Average(CellRange), try =Sum(CellRange)/CountA(CellRange). If you didn't know CountA is Count Absolute and ignores empty cells.

This is an old, possibly dead, thread but here goes anyway. You need to add a column to your data before you pivot it, containing the weekday name. You can do this using the following formula:=vlookup(weekday([datecell],2),Sheet2!A:B,2,false)where Sheet2 contains two columns: 1,Mon 2,Tue 3,Wed...

You don't want VLookup, you want SumIf. VLookup will only return the first match for each company. Assuming Company List in Columns A1:B100 and Summary List in D1:E10, with column headings, try SumIf (A:A,D2,B:B)

If you're using Excel, make sure that you have the Analysis ToolPak add-in enabled (Tools > Add-Ins > Analysis ToolPak) and then use the following formula:=EOMONTH(A1,0)+1This has takes the cell value of A1, makes it the end of the current month (zero months ahead) and adds one day.

I'm developing an Asset Management tool in Access and would like to pull users details, like contact details, from Active Directory. I'm guessing I can set up a Linked Table to AD but can't work out how to do this. Any clues please?

Sander I'm guessing there's a real need for the data to be in a specific order so, rather than exporting from the table, can you not export from a query with an Order By clause in it? I believe, and stand ready to be corrected, that the table shows data in the order in which it was entered...

MaxWeight Query I think I'd change the structure of the table slightly to make the query easier but it's a multi-stage process. Add another column, MinWeight Copy MaxWeight into MinWeight Increment MaxWeight by 9 Edit Row 1 MinWeight to be 0 Edit Row 8 MaxWeight to be 999999 Now you can write...

Now() vs Date I believe Now() is more application level, in that it requires the syntax =now() in Excel and Access. I'll be corrected if I'm wrong, no doubt, but I think you want to replace Now() with Date, being the VBA equivalent. __________ Alan Learning Access, fast! :eek:

Is it possible to do the above? I have an invoice tracking database where blocks of 500 invoice numbers are allocated to a biller. When invoices are received back with these numbers, the client, value and currency are entered into that record in the database. I want to validate the Currency...