Search results

Meir, Ok. Well, I'm sorry, I am unable to suggest anything further. Hopefully someone else will have an idea.

Meir, Did you try these tests with both a semi-colon and with a comma as the argument delimiter?

Meir, I am pretty sure the semi-colon rather than the comma is correct as the argument delimiter in Turkish version. Is it causing an error or some other problem?

Marnieg, I assume you are using the After Update event of the bau_first control. Is that right? Even if the focus was successfully going back to bau_first, this still would not achieve your purpose, as they could still just move on from there without further incident. You can try using the...

Paul, You can make a query based on both tables, and a Left Join from the primary key of the primary table to the primary key of the secondary table. Base your form on this query. Then, when you enter the data in the secondary table's "other field", the secondary table's primary key value...

Accessfever, Those are not single quotes. They are commas. You can run an Update Query on the table. Update [TheNameOfYourField] to: Replace([TheNameOfYourField],",","")

Captgnvr, Thanks for letting us know. I am very pleased to know that you have got something working nicely now, and I am gratified to learn that I was able to provide some help.

Re: How to connect table with an login interface? Sunny, If I understand your requirements correctly, then the code on the Submit button would be along these lines: If DLookup("[password]", "users", "[userId] = '" & Me.txtUsername & "'") = Me.txtPassword Then DoCmd.OpenForm...

Endri, If you just enter the age, then it is guaranteed to be incorrect after a period of less than a year. Whereas date of birth never goes out of date. If there is no way of determining the date of birth, but you have the age, I would arbitrarily make up a date of birth. I would choose a...

Khalid, Doesn't it work to just set the Close Button property of the form to No?

Tezread, Not sure exactly that I understand what you mean here. But to expand upon my earlier suggestion, does this match your purpose?... Dim NewTableName As String NewTableName = InputBox("What name do you want to give the table?") DBEngine(0)(0).Execute "SELECT * INTO " &...

You can only access the recordset if the form is open, so if you are trying to assess whether to open the form depending on whether there are records ...

Absolutely, Bob. I use Snagit a lot too. It's fantastic. Different tool, different purpose. If you want quick 'n dirty, Snagit can't keep up with Snipping Tool. ;)

Bob, I don't know what I'd do without the Snipping Tool these days. I use it multiple times every day! http://facets.datamanagementsolutions.biz/2009/01/snip-snip.html :)

Randolph, There is some good related information here, if you are interested: http://allenbrowne.com/AppIssueBadWord.html I don't know what we are doing different from each other. I just tried it, and (as I expected) it doesn't work for me. The new record opens, the focus goes there, and...

Ah... I see DK has already mentioned to you about the use of the word 'Date' as a field name. I am also surprised to see that you can set AllowAdditions back to False before entering any data... does that actually work ok?

Randolph, Try it like this: Private Sub All_Load_Click() If IsNull(Me.UniqueID) Then MsgBox "Please enter Unique ID" ElseIf IsNull(Me![Date]) Then MsgBox "Please enter Date" Else Me.AllowAdditions = True DoCmd.GoToRecord acActiveDataObject, , acNewRec...

MADali, LOL, well it looks like vbaInet and I both missed that >= vs => too! Maybe I should go into sales. ;) By the way... In my opinion, unnecessarily using variables is a common way to make code less clean. But if you are interested in clean, I always like to see references to...

Captgnvr, Can you please post the SQL view of your query to your reply? Thanks. Also, can you also please give some details of what is actually happening at the time you receive this error message -- do you have some code or macro that is being activated, or how are you going about trying to...

Rocco, Nigel is correct. The 'answered' variable is not available to both routines. If you putr an 'Option Explicit' in the header of your code, you will find you would get an error if you try to compile your code. If you want it to be a Global variable, it needs to be declared in a...