Search results

I have an A2010 form with a MoveUp and MoveDown button. A click will move the last record I clicked on, up or down. When on new record, both buttons should not be enabled. If I select a record by clicking in it and I click MoveDown until MoveDown is disabled, I wind up in the last record of...

Keeping with the spirit of the site (something sound) and this forum (something not pertaining to Access), lets take Mens Sana in Corpore Sano to a new level, especially the last bit. I've discovered intermittent fasting. Have been following it in the 16/8 version (fast 16 hours, feed 8 hours)...

This example shows two things: 1. How to set parameters for a stored query (useful for example when exporting query with specific data) 2. How to use a such stored query as recordset for a listbox or combobox.

Form/subform setup, and at least one child is required (e.g., in this setup, you cannot have an order without order lines). So the parent has at least one child or the parent must not exist. Anyone with an elegant solution to this and willing to share? A number of solutions float around the...

I've made a RH-menu, to move records. A2010 - open attached DB - place cursor in field Department in the middle of the form - right click - select MoveUp - do it again and again, then I get error when record is in second position from top in the table: "The expression you entered contains...

I am preparing a right-click menu with 2 items MoveUp and MoveDown, used to reorder records in a form. A2010. I've prepared code to move selected record up. Open DB, click on a record, click on cmdMoveUp - record moves up. I can run VBA from macro (and the macro will go into the menu items)...

http://www.bbc.com/news/world-us-canada-34507760

I've dissected CJ_London's Cascading Combos from here: http://www.access-programmers.co.uk/forums/showthread.php?t=275155 Been fiddling with it for ages, but have not been able to make it do a simple thing. I need a setup, where an unbound column (1) of Combo1 is shown, and restricts...

I have been making texts and mails and sending with Outlook for ages. But now I need to be able to prepare, in Access, customer mails with custom-chosen pictures (and their number) - and no, not signatures but visualisations of goods sold in a webshop. Anyone tried that? So far I've been...

strSQL = "UPDATE tblEmployeeJobs SET EmpID=@EmpID, JobID=@JobID, JobStart=@JobStart, JobEnd=@JobEnd WHERE EmbJobID=@EmpJobID" Set qdf = CurrentDb.CreateQueryDef("", strSQL) With qdf .Parameters("@EmpID") = Me.txtEmpID...

Many shy away from bound forms because they feel they cannot control updates of the bound record, if they wish to discard data. Unfortunately a lot of incorrect information is floating around the web - these things are FULLY controllable, no matter what you might google. Attached is an example...

If the bound column of a combo has nonzero width, then @;"This is some display text" ;;;;"This is some other display text" in the Format property, causes display of the text prior to typing and its reappearance if you wipe the contents of the field to which the combo is bound. But for combos...

Executions around the world, http://www.bbc.com/news/world-asia-34318470 Pakistan has executed at least 239 people since December 2014 In July Amnesty said it believed Iran had put 694 people to death between 1 January and 15 July In August, Amnesty International said Saudi Arabia had executed...

On this DL page https://www.microsoft.com/en-us/download/office.aspx they show:Microsoft Access Database Engine 2010 Redistributable I have read the description but am still to thick to figure out what it is. What does that code do? Does it replace or complement a plain vanilla Access 2010...

Anybody do the parent child form thingy with transactions and willing to share code? (I'm on my mobile so will provide link to transacted form latrr)

I am still confused about this constellation. I have plenty of applications developed in classic Access and interacting with all the other Office applications. But am in doubt whether they can be moved painlessly to the 365 thing. And now a client calls asking about Office 365 , and I have no...

Wauw - that post is an epitomy of brevity :D

Check this out, and say what you think. https://www.aclu.org/ordering-pizza There was an even scarier 60-minutes about this subject some time ago ...

Making a class for user authorisation/login would seem pretty smart, so the thing could keep it's appearance no matter what extra features where needed, and so the features could be added ad libitum. I've searched but did not find any VBA-based examples. If you know of one please provide some...

I have following code which works in Office 32: Declare Function GetDC Lib "user32" (ByVal hwnd As Long) As Long Declare Function ReleaseDC Lib "user32" (ByVal hwnd As Long, _ ByVal hdc As Long) As Long Declare Function GetDeviceCaps Lib "gdi32" (ByVal hdc As Long, _ ByVal nIndex As Long)...