Search results

Hi, I have a query that gets it’s criteria from a listbox selection. This is a date. The problem is that the query interprets some of these as “American” dates. For example, if I select 7/Apr/2017 in my list box what appears in the criteria row of the query is 4/07/2017 (4th of July). This only...

One more complication! When I select 07-Apr-2017 in the listbox it puts In (#4/07/2017#) in the query criteria row. It thinks 7th April is the 4th July? If I manually adjust that date in the criteria row to be 7/04/2017 it runs properly and returns the correct records. Is there a way to fix...

I finally got this working. I had to change the code that built my "In" expression for the criteria in the query by replacing the single quotes with # signs. The criteria was In (‘7/04/2017’) and it needed to be In (#7/04/2017#) to work with dates. Thanks Dave

Thanks static, I will try that

Thanks static, but I'm not sure where that code would go (It's getting way over my head, I can't believe what a saga it is to try to use dates in a listbox!). Is there a way to modify what is in the Row Source of my listbox (see below) to make these dates instead of text (but still...

I used "dd-mmm-yyyy". The dates in my listbox now look exactly like those in the table (and the query based on the table), but I still get the data mismatch error. Not sure why?

Thanks very much, I will give it a try

Hi, I have a listbox on a form populated by the following code behind a control button: SELECT DISTINCT [tblSMSdata].[Reporting Week Ending] FROM tblSMSdata UNION SELECT "ALL" FROM tblSMSdata The dates in the table are in the format dd-mmm-yyyy (25-Apr-2016) but in my Listbox the dates...

Hi, I have a form, frmSelectProjects, where I can select multiple criteria to run the query, qryJC_Manhours_By_Projects. I have created a report, rptJC_Manhours_By_Projects, based on the query but I need to be able to select multiple criteria (Projects) before the report runs. I don’t know how...

Hi, I have two schedules in Primavera P6. One is a copy of the other but with changes to the budgets for some activities. I want to build a database to help me quickly determine which activities have different budgets. I have dropped each schedule into an Excel spreadsheet and created two...

I still have the same problem. I have a total of 32 columns of data that I paste into my table from an Excel spreadsheet. The column I am having problems with is called Comments. If I paste text directly into the Comments field for a particular record I can paste over 600 characters no...

Hi, I use CDate() in a query calculated field to convert text to date format. The problem is that for records that don't have a date it returns #Error. Then my report crashes when I sort by date. Is there a way to use CDate and not get the #Error? Thanks very much Dave

Now I get date data type but it returns "error" for entries with no dates in them. This then crashes my report when I try to sort by date... Is there a way to use CDate() and not get an error when there is no date entered (just a null)? Thanks very much

Thanks very much Galaxiom

Thanks RuralGuy, but I tried this and I still can't change my text to dates. It's driving me crazy!

Hi, For various reasons I have to bring dates into my Table as Short Text and then convert them back to dates in my query. I usually use: Format ([myDate], "Medium Date") The frustrating thing is that sometimes it works like a charm but often it doesn't. Why? How can I get...

Thanks sneuberg, I paste the Excel data straight into a Table

Thanks, but that's way over my head

Hi, I have a table that I update by pasting in the contents of an Excel spreadsheet. Some of the entries in the Comments field are quite long. I have set this field to Long Text (no option for Memo) but it is still not capturing everything, only showing 255 characters. I tried...

Hi, I am trying to open a report with VBA using: DoCmd.OpenReport " rptNegTFinP6-COMMENTS-AreaMngr" When I click the button it starts trying to create a PDF of the report. What do I need to change so that I can just open the report? Thanks very much Dave