Search results

Hello, I am trying to implement a multiple criteria options to query my database, but I am getting the error "data type mismatch in criteria expression". I have checked through the code for syntax errors but can't spot any issue that I know of. What I want is any combination of the criteria...

Hello, I am looking for a code to automatically re-link ms access tables. My front-end and back-end are both in the same folder, but the folder location ma changing machine locations. Google search found me this link links http://allenbrowne.com/ser-13.html but it's for old versions of ms...

Hi. From the code below, I want to programmatically copy and rename the files I am adding into the table tblObjects to be same as the primary key which is ObjectID, i.e. /Images/1.jpeg etc and then return the relative filepath containing all the images to be in a folder called "Images" within...

Hello everyone. I have this code that I adapted for one of my projects years back to save images into a table but now I just cant get it to work. When I tried it this time, I was getting an error "The code in this project must be updated for use on 64-bit system", and so I found some suggestion...

Greetings, I want to lock data editing on the details form for the "data" user based on: whether the date the record was added is equal or greater than today's date and the time elapsed is equal or more than 20 minutes If DLookup("[data]", "tblCoordinators", "[userID]='" &...

Hi, I have a form with text boxes for adding new Event. I want to check if the mandatory ones have data in them. I need this to ensure that the subform used to add participants to the Events is visible only when the mandatory text boxes have data. How can this be done?

Hi, Please, where can I find a working sample of how to re-link tables if the back-end has moved to a different directory either automatically or by asking the user to choose the new location for the back-end? I have tried to find some but they don't work that way. The closest I think would...

Hi, I want to recreat my menu form with a switchboard created through the switchboard wizard. The only thing is that the new switchboard buttons aren't catchy; I want buttons with images on them corresponding to the button action. Here is my switchboard for easy reference. I will...

Hi, I would like to know how to pass a WHERE condition behind my search button on a form to a query so that I can open reports based only on the search results from the Where condition. This is my code: If Len(strWhere) > 0 Then If Nz(DCount("*", "qryEvents", Left(strWhere...

Hi, I am using a union query to generate a bar-chart based on data for year 2018 thus far. However, the query returns a wrong bar-chart when I enter a year that does not have data. For instance, open the form named "F_VENTS_STATISTICS" and enter 2017 in the prompt window; the data generated for...

Hi, I have WHERE condition declared under a Search button for programmatically searching a table through multiple input controls on a form. I would like to know how i can open a filtered report based on the same strWhere condition. Under a CmdPrint button I tried DoCmd.OpenReport...

Hi, I have a continuous form bound to a query. I want to filter this form with any date inputted into a text box through a pop-up calendar control. The default date in the text box should be Date(). In the query, I set the criteria on Call_Date filled as follows but the form does not requery...

Hi, I am creating a query that should filter records of events based on multiple fields. The filters should work with any combination of field criteria, but only two of the four field are working properly, as follows: 1. a text box for searching with event name (free text) - this is working...

Hi, I was looking for an ordinary calender I could re-use in my Access project, then I found just the kind I want done by Allen at http://allenbrowne.com/ser-51.html# I am using this calendar pop-up merely to check dates (not to populate any control). But my issue is that I want to change the...

I have a form that has a listbox and a subform. The listbox lists names of events, start date and end date. The subform bellow reveals names of participants to the event that is clicked in the listbox. Against each participant's name is a button to delete the participant. How can I hide or...

Hi, I am using two combo boxes to filter a list box with the code below. The combo boxes work, but when the form opens, the list box is empty until it is filtered using the combo boxes. I want the list box to return all records when no filter is applied. Here is the code: SELECT...

I am writing a small database using MS Access 2007. I have in it a function for running queries and printing reports. Printing works just fine if any one of the multiple query criteria is give. I also want to trap errors and present a message if the user clicks the "Print" button without...

Hi, Just starting with web databases. I have about six tables which are joined with a junction table called "t_incident_persons" as shown below: t_persons +-----------+-----------+----------+----------+ | PersonID | FamilyName| FirstName| CountryID|...

I want to insert OfficerID of the officer currently logged in as a default value into the table T_FileCases when they create a new record. Already in the login form I have a field that holds the OfficerID when logged in successfully. Is it anything close to this?: Private Sub...

Hi, Please, I have limited logic capability on this. The text boxes for search criteria and the SEARCH button are on the main form while the search results are on a pop up form. I do not want the details form to open if the provided criteria does not match with any record in the database...