Search results

I actually just designed something similar to this. This will create a passthrough query. make a table using that query then delete both temp queries. mySQL is a PL/SQL statement if you are using and oracle driver. tblNm is where you want the data to go. connect is the oracle connection...

In Excell things like this are easy. Just start recording a macro, do what you want, stop it, then look at the code. FYI, If you are trying to manipulate Excel from Access create the macro within excell then just call to that macro from access using an excel object. -TJ

Forms also have an annoying option called popup that you can use to force it to the top of the screen. You can then use it sort of like a custom message box.

Here is a link to another forum that explains how to create a basic thread in VB. You might have to fiddle with it a bit to port it over to VBA. This is a windows specific function so you could probably search for the function name in google or something and see how it is done in other...

I would have to agree with the idea of the key press event. Except instead of issuing errors I would just delete the character that they entered. Let them type letters all day, just don't allow it to enter the box. This would be less annoying when you fat finger the number keys up top while typing.

For something like this it get's a little bit complex. I have done things similar though so it is not impossible. What I would do is remove the binding from the form so that it points to no table. Then use a module to insert a single record into the form each time a new record is needed. when...

You have to use the file system object. Here is a basic set that I use to look for files that have the same names but different dates. If there is a file with a newer date than one I have linked in it issues an error. Private Function isNewFile(ByRef curDate As Date, ByRef strCurDt As...

I don't know how you have your stuff layed out, but you could always create a crosstab as a new table then reopen it in a module in order to update the fields to match your goal. Something like this: Public Function updaterecords() Dim rst As DAO.Recordset Dim fldCount As Integer...