Search results

I can't see what is the problem here it's should work as you stated. Do you get an error message or the code not behaving as expected when filling the txt1 textbox?

Indeed it's the shortcut property of the form.

Sorry if my answer is a little bit long. Technically, I and PD know how to do it, but if I want to only upload the logos which is not a thing, I need the logo data which should be provided by the PD, and I know the data do not exist and need to be collected (usually the PD should collect all...

First, I found the Debates forum the only one for this topic. My company's CEO asked me to upload the vendors' logo to their profile in our ERP system (my job title is a software developer), and it's the job of the purchasing department as far as I know. I don't have the resources or any...

mmmm, I think I understood what happed, Debug.Print "VarType f is " & VarType(f) return the type of the defult property, not the variable type, I didn't think to use the watch windows to verify the type of the object. Thanks.

I am trying to instantiate a folder object to list the files inside a specified folder through GetFolder Menod of "Scripting.FileSystemObject" object, and it's returning a string instead of a Folder object! Attached: 1. a screenshot of the code and its debugging output. 2. a screenshot of the...

yes it's, you should do to string the same thing you did to dates. 'numbers need nothing Example: Me.Filter = " intNo = 15" 'With Variables Me.Filter = " intNo = " & Me.txtNumber 'String need single quotes Example: Me.Filter = " strName = 'Joe'" 'With Variables: Me.Filter = "...

Hi Chris for me usually, I filter using two operators ( =, Like) it goes like this: ' Example #1 Private Sub cmdSearch_Click() Me.Filter = " strInvoiceNo & strVendorNo Like '*" & Me.txtSearch & "*'" Me.FilterOn = True End Sub ' Example #2 Private Sub cmdSearch_Click()...

This is great thanks, personally I prefer Shades of Grey.

Pat Hartman I looked up RAD on Wikipedia and one of the process is Construction phase suggest Unite Testing for example and access doesn't support that - there is add-in called rubberduck can give such feature to VBE - and one of the condition of unite testing is to decouple the dependencies...

Thanks CJ_London for the links they wear helpful, and the answer by Mathieu Guindon in the stack overflow is great, I am familiar with Mathieu Guindon blog and i in love hate relationship with it.

Thanks for the advices but I pass this stage and already working with classes and objects, refer to my replay to neuroman9999

I have the feeling that there is no easy way, due to complexity and disburse of ideas. in some sense, it gives me relief that I am not doing it wrong. The Thing is when I reading a book on OOP – or another subject. I been showered with concepts and words, that the writer expects me to know...

Hi to you all, declaimer I am new to programming and measure my self as going from beginner trying to enter intermediate so bear with me. in those days i working on an access application for my company for data entry, and i am in struggle to fine the right design pattern for OOP...

In this case both date and text textboxs is not working If Not IsNull(Me.Txt_DefaultDate) Then Me.Txt_Attendance_Date.DefaultValue = "'" & Me.Txt_DefaultDate & "'" If Not IsNull(Me.Txt_DefaultVendorName) Then Me.Txt_Vendor_Name.DefaultValue = """" & Me.Txt_DefaultVendorName & """" the four...

hi guys I have weird behavior when i am tring to assign value from textbox to another textbox default value, the example will make it clear. Environment: windows 10 office 365 access VBA ' this is not working Me.Txt_Vendor_Name.DefaultValue = """ & Me.Txt_DefaultVendorName & """ ' this...

Hi Michel

First thank you SQL_Hell for the effort you putting in this thread. you are right, the error message changed after i used the comma now the issue changed to authentication issue -i think- (photo attached). The SQL configured to use windows authentication and when connection the error message...

I did it as you says, the telnet seem to make a connection but it's closed when i start typing charts, regrading ODBC it's give me same result as before (photos attached)

Don't think so because i just replay to another post by him and it's work fine, it's more likely the hyperlink post limitation for new users.