Search results

I'm currently playing with some code to deal with plurals in a combo box. So depending on a text box that accepts a numeric value, the combo will show either singular or plural depending on the value in the text box. The code is If Me.Quantity.Value > 1 Then Me.Combo0.ColumnWidths...

Is there an event or a way to detect when a form's native filter button is clicked?

I'm populating an unbound text box from a column in a combo box. This combo is selecting a suburb from a rowsource dependent on the country of origin. For each country, the post code is a fixed numeric length. Each of the tables is formatted to show the leading zero, and this displays just fine...

I have the following code under a button, which opens the file explorer window, and then moves the selected document to the target file and notes its location in the DB. In 64 bit the file explorer windows does not open and the MsgBox "File selection was canceled.", vbInformation is shown...

I've just taken possession of a new pc with windows 11, and of course the latest version of access. One of my DB's (I'm sure there will be others) is now giving me the following error, which I have no idea how to fix. I'm pretty sure it is code I found in these forums sometime ago.

I'm currently creating a pseudo combo box. The aim being to create a combo box that has a more flexible search. I'm using an unbound text box and button with an unbound list box (populated using data input into the text box, it's row source being a query that uses a Like "*" & [me.textbox] &...

The following SQL works fine as a Query StrSQL = "INSERT INTO TBL_TastNote ( WineID, AuthID, [Note] ) " & _ "SELECT TBL_Wine.WineID, TBL_Wine.Wine, 4 AS Expr1, 'See Attatched PDF' AS Expr2 " & _ "FROM TBL_Wine " & _ "WHERE...

@ghudson do you have a newer version of the Browse [Find a directory or file]? The version at the link is .mdb which is not compatible with current versions of Access

In a long-term DB, I have a search from that had been working flawlessly. However, when I opened the DB this morning and tried loading the form I got a series of "Enter Parameter Value" dialogue boxes (relating to controls on the form) culminating in an "Error 3 Return without GoSub!", then when...

I believe that the normal behaviour of a continuous form, is that when the Record Selector is clicked the focus moves as the mouse button is depressed. All good (y) What I am trying to achieve is to open a (filtered) pop-up form that is based on the record that has been clicked. I am using the...

I must be missing something very basis as the following is throwing a Runtime Error 13 Type Mismatch Dim rst As Recordset Set rst = Me.RecordsetClone On the Set command The code is in the On Click event of a button

If you have imported data that has originated in a non-English-speaking country, you will find that words containing accented characters might not get picked up in searches or that filters fail. This function can be used to search a string and replace such characters with standard Latin...

I'm working on a routine to strip out accented characters from a string and replace them with standard Latin characters. The code does pretty much what I'm looking for, except that it doesn't seem to discriminate between upper and lower case characters. The code looks in part like; Select...

Not sure if this is the appropriate place to ask this question. If not (mods) please move it :) I'm just wondering if anyone has any feed back on Udemy in general and in the above course specifically? At AUD 19.99 (down from AUD 124.99 for the next 5 hours) I don't see a downside given that...

The following SQL is throwing a 3464 Run time error Data type mismatch in criteria expression 'SQL statment to delete exsiting record(s) relating to current wine StrSQL = "DELETE TBL_WineGrape.WineID, TBL_WineGrape.WineGrapeID " & _ "FROM TBL_WineGrape " & _...

I have, or rather had, both a click and double click events on a sub form in datasheet view. On their own, each performed their task as expected. However, when both were enabled at the same time, the Click event was firing in preference to the double click event firing. My understanding is click...

@arnelgp base on the code you produced for me earlier I am now trying to expand that concept. I have a de-normalised table containing grape synonyms eg. Pinot Grigio / Pinot Gris / Grauburg What I'm trying to do is split them into 2 new records (in this case, in others it could be one or...

I've been banging my head on my keyboard for some time of this piece of code QryAppend = "INSERT INTO TBL_Grape2 [( Grape )] " & _ "values ( '" & GrapeSendStr & "' ) ;" When it tries to run, I'm getting a "Syntax error in INSERT INTO statement". I'm sure it's something very...

I suspect I know the answer to this question (and it is "NO") already, but just wanted to check; Is it possible to format the Form Caption, i.e. to change the colour of the text, partially or wholly, or bold /italic it?