Search results

Someone is using an Access db I have written and it includes code which runs fine on my computer. However, on hers, the code does not run at all. Is there a setting I can change?

I want to re-link my front end to the tables, but the Linked Table Manager now looks completely different and has buttons labelled "Refresh", "Relink", "Add" and "Expand All" among others. Can anyone please direct me to some instructions on how to use this form. I have tried all sorts of...

An expression to get the last day of this year is DateSerial(Year(Date()),12,31) but I am trying to figure out expressions for both the First Day and the Last Day of LAST year. This is so that I can prepare queries for sales info etc for the whole of last year.

Is there an add-on program for Access whereby you could type in a UK postcode and it would display the addresses belonging to that postcode?

In the query design grid I'm trying to concatenate a short piece of text with a currency field. It works, but unfortunately the currency then appears with lots of decimal places even though it appears everywhere else with the normal 2. I've tried setting it to 2 in the Properties formatting...

Access 2016 (bought as pre-loaded on a Dell). Strange phenonema recently both on desktop and laptop. In form or report design, after grouping two objects and using Left/Right align or sizing to smallest/largest, it works the first time, although it leaves the options box on the screen. Next...

I often use Ctrl+V for Paste. Is there a shortcut for PasteAppend?

A 2016. Under options, if I choose Datasheet and then Default Font size, I see a combo box with the expected values. However, after selecting one and then closing/re-opening the database, the font size has not changed in any subforms viewed as Datasheets. If I change the value for default...

In Access 2016 on the debug toolbar, I can't see the buttons for "Comment Block" and "UnComment Block" and I can't see any option to bring them onto the toolbar. Can anyone advise on how to bring these two buttons to life?

In Access 2016, on more than one computer, the Number datatype in table design offers only Long Integer. There is no option for Byte, Integer, Single, Double etc. At the moment, the only way round seems to be to create the table in another version and then lift it across. Does anyone know if...

In Access 2016, text boxes in reports seem to be defaulted to border style: 'Solid'. Does anyone know how to change that default to 'Transparent'? Similarly, the shading in section headers seems to be Alternating colours. I am hoping to set that default such that they are all the same. Any...

I am wanting to insert a Barcode ActiveX control, but it is not listed. In an instruction video, after clicking on ActiveX Controls, the one named "ABarcodeActiveX" is at the top of the list. Can anyone advise me how I can obtain this. Thanks.

I enter workshifts for staff and need to check to make sure that a person is not already working somewhere else on that date. I am using the DLookUp function to see if the proposed date matches any existing bookings. This works fine as long as there is only one date standing in the LookUp...

With a simple form and datasheet subform, if the user tries to create a new record in the subform before a record has been created in the parent form, then Access displays a message which may not be understood by the user. I would like to handle it so that I can give a more helpful message...

In writing a simple expression to calculate pay, I have in VB written ShiftPay = WeekdayRate ......where the WeekdayRate is stored in a module as a constant. If I had 2 or more shops, I would have more lines in the module and would have more blocks of code. I would prefer to have the...

In a table (HOLIDAY), I have noted some dates as being official holidays. Within a form, I am trying to use the DLookup function to see if the date I am using is recorded as being a Holiday. My line is: If Forms!frmShift!StartDate = DLookup("HolDate", "HOLIDAY", "HolDate =...

Using a database written in Access 2000. Simple form with datasheet subform. In the subform, right-click and try to choose "Delete Record", but the option is greyed out. Also the toolbar "Delete Record" button is greyed out. Have checked out the Trusted section and the "Allow Deletions"...