Search results

I don't have option explicit on every module. Even though everything works fine now, should I still do it?

Hi everyone A rookie programmer here, just wanting to get more information. I'm noticing most (if not every time) I add new VBA code, things work fine momentarily but afterwards there seems to be some sort of error that comes along with the addition of new VBA (e.g. form won't open due to...

I just decompiled the databased and now it works fine. Thank you

Thank you for the reply. Unfortunately I changed the VBA and I'm still getting the same error.

Hi everyone So i'm working on creating a classic login form. The VBA I wrote did initially work but now suddenly I get this error The OpenForm action was canceled I don't know what happened but if someone could have a look at my VBA and maybe offer some guidance, that would be appreciated...

Hi everyone I'm just wondering is there a way to highlight one specific column with a different color than the rest of the list box columns? I've played around with it but nothing worked so I'm just wondering is this even possible? I set the list box to one color but is there a way to just make...

Hi everyone I have a form that contains a list box with the row source = a query between two tables and various text boxes bound to each column in the list box. I've introduced a 3rd table with three columns (2 date/time and 1 combo box data types). I've edited the query to include these 3 new...

Thanks guys

Hi everyone So my problem is relatively simple but I don't know how to approach it. I have a working search box that filters what the user types in real time, however how do I add default text in the search bar that says "Type here" for example and goes away once the cursor is placed there and...

For step 3 Open up any module. Compile it via Debug, Compile.., then File, Save. I don't have any previous module created, but whenever I select Module or Class Module or Visual Basic, I keep getting the same Microsoft Access has stopped working... Thoughts?

Thank you sir, very much I clicked on the link and I get "Bad Request"

No sir, I'm still relatively new with access

To compile in VBA is this correct? DoCmd.RunCommand acCmdMakeMDEFile

Hi everyone So I ran into a problem I'm sure access 2010 is notorious for but every time I try to open this one form, I'm hit with this error. I don't remember doing anything out of the ordinary last time I worked on it but now I'm not able to do the "form view". I tried going into file >...

nevermind i got it working, thank you all!:)

Basically with the second part my intention was to return the first instance of a record that matches what the user presently typed out e.g. user types "Joh" and the first instance returned "John Smith".

I get this highlighted in yellow. Do I also need to define Len and InStr? If Len(Me.txtKeywords) <> 0 And InStr(Len(txtKeywords), txtKeywords, " ", vbTextCompare) Then

Hi everyone, a real access novice here with a problem regarding this keyword search. Basically I have listbox with a query between two tables as a control source. The idea is for the user to type the listbox would filter itself and get shorter based on what the user types and as they type and...

Basically this is a company database designed to track organizations that academic programs at an educational institute uses for student internships. Relevant information related to the organizations such as supplementary services, authorization, affiliation agreements, etc. are listed within...

Hi everyone So I'm creating an access database using three tables, so far, they are: tblCompany tblPrograms tblSupplementary The Company table will have one or more than one program and/supplementary service. Thus, the program(s) and supplementary(ies) columns appear as dropdown lists in the...