Search results

@Gas-Man, Yes I do set it to the label. Before update attribute works, but not the left-focus, as described above. Regards,

Good day to all, The code I have used before within the program to set the focus is not working. It Goes to the next field. I have put the code into the Private Sub section using the LEFT FOCUS attribute. As I click into the next field, thus leaving the date field, the if statement below...

@Spikepl, I have done so, I tried to format Column A and B as text. Column A turns to an Exponential number (something like 2345909+E12) [Once imported into Access it remained the same.] Column B was fine formatting it to text, BUT at line 72 the date changed to a 5 digit number. Hence...

Thank you, I'll go and do!

Good day to all, May this post find you well. I do need some expert advise. Attached in the ZIPPED file is an Excel spreadsheet. Columns A is all numeric, and needs to be represented in access as a text field. Column B is a mixed format of dates entered and in some instances only plain numeric...

I'll explore - thanking you in advance.

Good day to you all, I need a facility in the access VBA coding to check if a directory exist. I it does exist, I need to open it and check for a specific file. Or if the directory (folder) exist, to determine or display folders within. I hope someone can help me in this regard. Much...

Thank you. The Problem is solved. Much appreciated. Blessings to all.

Thanks to the appropriate answers. I forgot about the required fields, I was struggling with a full query, using all the fields and the override (continue yes) did not work. Hence out of frustration I just selected a few fields. Thanks I am going back to check the required fields. Will comments...

Good day, I must be getting old, Many times I have appended tables. But now I am struggling even trying to append 4 fields defined as text. Please view attached zip file.

Thank you both for your prompt reply. Blessings.

Good day, I have setup a test query ("Query1") whereby the query has to display a running total as long as the Department is the same. The problem I am having is that I get a total of all records being displayed. Appreciate the help, Blessings

My apologies, I add an attribute before update. The code adds individual fields and compares it to a check field. If out of balance it sets a message and the focus to one of the input fields, but the code does not direct the action to the input form. It closes and goes back to the main menu. The...

Hello once again to all out there! The Libraries in Access is a pain, to many, but to all the gurus, please tel me why would I get this error? I am setting the field label, as in other programs. Your help is appreciated, Blessings. Object doesn't support this property or method (Error 438)

[Resolved] Re: Run-time error '3464' Data type mismatch in criteria expression @BlueIshDan, Thx the second solution worked, I will continue checking to see if all is well. Thanks for all the advice. Blessings.

@BlueIshDan, Thx, The first solution provided give no error, but nor does it give me a record. If sort of find a EOF. tWhere = " [P_DateF]=" & txtSDate & " ORDER BY [P_DateF] ASC" ' strSQL = "SELECT * FROM [Prices] WHERE " & tWhere Set rs = db.OpenRecordset(strSQL) If rs.EOF...

P_DateF Data type Date/Time Format Short Date Dim txtSDate As Date Anything else?

Hello to all, hope you are all well. Sometimes I don't understand Bill Gates. Here is my code: tWhere = " [P_DateF]='" & txtSDate & "' ORDER BY '" & "[P_DateF]'" ' strSQL = "SELECT * FROM [Prices] WHERE " & tWhere Set rs = db.OpenRecordset(strSQL) both [P_DatF] and txtSDate =...

Re: [Resolved] VBA SQL SELECT SUM GROUP not working @Smig, @plog, @plog: I still need to do the SQL debug thing, not quite sure, but I I think to understand that I can use the SQL tab within the query module to get it to work? In the mean time, herewith the code. The sumOfAmount is not...

Hello, The ampersands (&)? --- According to the VBA help it was set out as separate strings being concatenated. I just thought maybe the compiler doesn't like the syntax, once had something similar. OK! I will setup a query, and then reference it in the sql string? Is that the idea? Blessings,