Search results

So that being said, there is no way to display upper case of a bound control date in subform?

Too much formatting here Im a bit confuse. So ur saying that I should remove the format in my table to nothing and the field format should be Date/Time? Also remove the format in the subform field to nothing? So now the date shown in subform is : 2015-10-01 In the afterupdate event of the field...

My subform is set to datasheet view and the data field has a calendar picker. Whenever the date is chosen, I set the format to: ddmmmyyyy which shows 03-oct-2015.

I did use ucase but it deosnt work. Because the data in the field date is in format yyyy-Me may-dd i think thats why

Hi, I have set the table format to ddmmmyyyy and field in subform to ddmmmyyyy however I cant make it display in Uppercase..! I have tried to set the field mask input to > but it does not reconigze as it's a date. I tried after update event of the field to ucase but it does not work, however...

Thanks, but I found this way works too: Left([UNIT_PERSON],1) = """ & UNIT & """

This works good! However, I just Wonder instead of setting the unit W, and X into the code, can I set them in a Public Const String? Like: Public Const strUnitC As String = "C"

Know how to implement the code in that way?

That way will hardcode the W and X. Is it possible to create another table to set the location for each first letter unit and reference it? Example: tblUnit [Unit] [Location] A - Alberta B - Alberta C - Alberta W - Toronto X - Toronto Now, reference the filter base on the field Location of...

Hi, My working floor is divided in many Unit, and 2 locations (Ontario & Alberta) I have a table that contains all data of sales per department (tblSales) [Unit] [Items] [Price] There are many Units such as: AB, AC, A3, A5, B2, B4, B5, BG, D4, DV, W2, WE, X1, XD, XS, etc...

Thanks, that make sense.. But I have more knowledge on vba than access vba, so that's why I used the old way to enumerate data thru vba. As per my post above, I stated that I associate a range of company in my vba code and I used, Instr..to detect if the record has the company name. If I have...

Get it..! But it will not solve my other issue. I have another combobox which has 2 value: Canada or USA. I will need to filter those base on the BIGCOMPANY. If the USA is selected in the combobox, then it will filter to only show Apple, Samsung and HTC which are my BIGCOMPANY associated.

After update the combobox, it asks to enter the Value Parameter?? What do you mean??

Data such as Apple, Samsung or HTC. I tried to do the filter but it doesn't work by calling the filter using "Like".

Hi, I am declaring couple string in a constant: Public Const BIGCOMPANY As String "Apple, Samsung, HTC" And I wonder if anyone know I can apply this filter to my code, so in the combobox, if they choose BIGCOMPANY, it will filter thru the listing all record that has those company in the field...

I guess nevermind. I just went through concatenate function from Allen Browne, and the speed of the process is not much more faster than the comparing code that I am doing. Thanks.

I get what you mean, however, in the tblTemp which are data coming from an excel, they have 1 rows for each items regardless the members. If the member has 10 items, then it will create 10 rows. In Access, I will need to manage per user regardless their items. So I will need 1 user per record...

Okai,I just want to make sure that you understand the data come from tblTemp to tblData. Then: If the data already exist in tblData, then it will update to the same value as tblTemp. Reason for so, because the tblTemp will have new monthly data which has a field [BALANCE] in it, however...

If the tblData already have SHORT - CSD - 012344, and the tblTemp has : SHORT - CSD - 012344 Then it will update the tblData from the tblTemp, and while updating, if the SHORT is already there in tblData, then it will not do anything to that SHORT field which is [PROD] I don't want to delete...

Every month, I have a new reports coming out, then I will need to compare those record on the new report to the old one and if there are new, then add, if old, then just replace existing data. So it's a monthly process to compare new record to old record. rs = tblTemp rs1 = tblData A/ When an...