Search results

Thanks. I have checked it, it is yes/no field. Could be any other issue?

Hoping to get some help if I could. Thanks in advance.

Thanks. After commenting it out, I am getting runtime error '13' Type mismatch stopping at Set rst = db.OpenRecordset(SQLStmt, dbOpenDynaset)

I used to use following code quite successfully but now using it after a long time, I noticed that code simply keeps running between While Not rst.EOF and Wend lines. This lifts the email address from a table where I have users listed and true false in front of their names. So it is designed...

So very grateful for the help. It works great.

Thanks for the prompt response. Kindly have a look on the second para of my earlier post which I edited after you responded.

Thanks for your kind effort. You got it right in terms of when and how we treat quarters and years. In terms of using the code, could you kindly guide me through. I suppose I can use both codes individually. But if I were to derive quarters, how do I get FY as part of the quarter description...

Hi namliam I apologise for reverting. I still seem to have an issue as some dates are incorrectly falling into wrong quarter. I have used the following code and attached a spreadsheet which shows what dates should fall into what quarters. Could you kindly see if the code can be improved...

Thank you so much. So as I understand the refs I have got are sufficient for early binding. However, when I publish the mde in Windows 7, these refs also change. Again that should still handle. So may be the issue I have described is resulting from something else. And you are right I have a...

Thanks. Yes I am using early binding according to what I have read. I have right refs. Now does this mean that I have to use late binding and does that mean adding some code to ensure my app handles all issues?

Sorry where is the link?

Thank you very much. I don't have a great deal of understanding on early binding. I tried once but did not quite see how I use it. But now that you have indicated that this could be used in Citrix (Yes we have Excel 2007) then help me a little to how to use it. Does it go into the reports...

With the dreaded roll out to chrome books, our business is now using Citrix to rum the application I wrote in Ms Access 2003 but published in 2007. Since the roll out, users are unable to analyse reports in Excel or PDF it or snapshot it. i am sure I am not the first person to have this issue...

Many thanks for your input. As this import routine is already working, could you guide me on additional code I need to insert so that import is cancelled without having to handle errors.

Thanks. This is a good idea and I should be able to use this if it has no impact. But I can't stop users stuffing up the rows or even adding a new column.

I am using following routine to lift data from Excel files into Access tables. Whole thing works, well, most of the time. The only issue I have is the spreadsheets are received from warehouses and even though they have been given strict instruction to stick to the template, I have had to...

I am very grateful for the advice (I have done as suggested) and changes to the code. Yes it was more than persevering and kudos to yourself for being patient. Kind regards to you and others who have contributed.

Many thanks for pointing out the error. It has actually addressed the issue to some extent. I was having issues with some dates in Sep 14 but I still have issues for dates in march which should be assigned quarter 4 according to the convention. Monday, 30 March 2015 Qtr 3-2015...

I am referring to this as Buildercomp. This code is slightly amended from what was posted by namaliam.

Thanks once again. I have attached a test db with the data, query and function. Thanks for persevering with me.