Search results

Hi everyone Below is a screenshot of a column called "Codes" on a report and as you can see, some of them are separated by commas. Is there a way for me to display these point by point (code by code) on a report? E.g. 0008 '1077 '1165 Any thoughts or suggestions are welcomed and...

Hi arnelgp It turns out the date column was not in Short Date format, I made this change and the column now displays everything properly. Thank you for your response anyway, I appreciate it!

Hi everyone So I'm back from a brief hiatus and upon opening access, I noticed something very odd. I have a datasheet in split-form view and it's data is based off a query which extracts a number of columns from the main table and one of the date fields called InsuranceExpiryDate is displaying...

You're right. I'm glad you mentioned this before I invest more work into it, it's good timing to review good design principles, since 2 out of 3 major tables are in there, one more still needs to be included with clean data. I was thinking of continuing without the third but after reviewing...

For sure. I presented what I have so far to some of the users and they liked it. But was just wondering if there is any way to in addition look up multiple columns at once, to look search one specific column as well. If not, I appreciate it and will also look at refining the design of this...

No, I didn't develop. Just building upon it. As a side note, although there aren't any relationships for the two tables. Originally data in both tables were an absolute mess, i imported them into a couple excel files, did some data cleanup, imported them back into the database. So even though...

Well basically this database just keeps track of agency and subsidiary (branches of agency) information working with this one educational institute. The information includes: agency name, subsidiary name, educational programs (listed as codes), placement types (community, long term care)...

Hello everyone, I have a datasheet in split-form view and a search bar that filters based on whatever the user types in and I'm happy to say works very well. I have attached the SQL of the query this datasheet uses. So as you can see from the screenshot whatever the user types in is based on...

******UPDATE******* Hi Everyone, So I have a query that extracts 6 fields from a table (but some I decided to not show here). In this query, there are two end/expiry date fields (AAFinalDate and InsuranceExpiryDate) independent of each other as shown in the attachment and one yes/no field...

So I was thinking... looking at Allen Browne's methods, I was thinking the first might suffice for what I'm trying to do. essentially making a query and having ">= [StartDate] < [EndDate] + 1" in the date field under criteria. Which prompts the user to enter the date in a dialog box, however...

I'm using one table yes, however there's a lot of columns in it, and most are not needed for this report, only 6 are needed. So when you say delete all agencyinfo, i'm left with nothing in the query

Sorry for being dense but im still not sure exactly where CDate(mytextdatefield) goes. I attached a screenshot of the report query in design view and the SQL Also, Access won't let me change the data type in the original column without deleting some records :/

Do you mean put CDate(mytextdatefield) in format for AA Final Date's data type?

It's not date/time it is text but the format is m/d/yyyyShould I change it to Date/Time?

Here's the code: Private Sub cmdPreview_Click() On Error GoTo Err_Handler 'Remove the single quote from start of this line once you have it working. 'Purpose: Filter a report to a date range. 'Documentation: http://allenbrowne.com/casu-08.html 'Note: Filter uses...

Hi Ridders, I chose a) and followed Allen Browne's example as best I could but when I went to pressed the button that would generate the report and the date column this is based on gives me some of the dates but also ones that aren't within range, I went really specific in the date range...

Hi everyone So I have this datasheet with two expiry date fields (affiliation agreement and insurance expiry) which are totally independent of each other as well as a column with yes/no values. I was told I need to make a report criteria based on these three things. Thus the user needs to...

Thank you very much!

Hi guys I tried both your examples and I got the same error, which was Runtime error 3709 The Search key was not found in any record Private Sub Combo565_AfterUpdate() Dim frm As Form Set frm = Forms!frmNewAgencySearch frm.Filter = "[Program(s)]=" & Me.Combo565 frm.FilterOn =...

Hi everyone, I know this is similar to a post I've created before however things are slightly different now. Basically I have a form in splitform view and all i have right now is a search bar that filters based on what the user types in. However I would like to add a combo box with 2 column...