ConfusedMay
Last Activity: Mar 8 '11, 10:46 PM
Joined: Apr 23 '07
Location:
-
Thank you.... I'll give it a try and let you know the outcome -
text box value and run code
Hi,
I'm currently working on Access 2010 form for touch screen. On my form I have a text box called txtid where users will have to enter their employee ID. employee ID will equal to 4 characters. What I want is once user enters the last digit of their ID, I want it to trigger my code without having them to click a button (i.e enter button) can I do that? If yes, where should I put the code? because when I put it on the afterUpdate... -
I figured it out. The problem is my calendar. After deleting the calendar and create a new calendar again, the requery worked. Thank you so much for all your help...Leave a comment:
-
Hi Mseo,
I changed the textbox into combobox and created the mousedown event like you told me to, but it still not requerying my subform.
my subform is based on a query, here is the code for the query
...Code:SELECT IIf([InOut]=1,"In","Out") AS Status, dbo_v_log.time, dbo_v_log.ID, DateValue([timestamp]) AS [date] FROM dbo_v_log WHERE (((dbo_v_log.ID)=[forms]![supervisor]![textid])
Leave a comment:
-
requery my subform based on date criteria from the main form
Hi,
I'm using access 2003. I have a textbox called txtdate on the main form and when I click this textbox I have a calendar pop up and users can select which date they want it to be appear on this textbox.
I also have a subform called child181 that the source object is coming form a query called InOut. This subform will show all the in and out inventories.
What I want is when user select the date from the calendar, I... -
Hi Beacon,
Just one quick question, why I need to put the code on the before update event instead of the after update event? I thought whatever that I need code change after whatever stuff that I enter, I need to put it on the after update event. Sorry if the question is kind of dumb, I'm new at VBA and still has a lot to learn.
Thank you...Leave a comment:
-
Hi all,
Thank you so much for all your replies and yes beacon, my bad, I created it on the after update when it's suppose to be on the before update.
before update is worked now...
Thank you....Leave a comment:
-
Hi Beacon,
sorry for the late reply...
here is the code that I have
for combo box, I called it txtcustorder
on the property, it has bound column -- 2
Row source type -- table/query
Row source --on the after update event:Code:SELECT cust_ORDER.cust_ID,cust_ORDER.STATUS FROM cust_ORDER GROUP BY cust_ORDER.cust_ID, cust_ORDER.STATUS ORDER BY cust_ORDER.cust_ID;
...Leave a comment:
-
Thank you for the quick response.
When I tried to put your code, it didn't work quite well. when I choose from my combo box, it didn't change the value, instead it went back to the first value on the combo box list, for example, when I choose cust order 11111, it displayed cust order 00000 on the combo box since 00000 is the first cust order on the list. Am I missing something?Leave a comment:
-
how to change font color in combo box based on criteria
Hi experts,
Could you please help me with this situation? I'm using Access 2003 and I have a form with combo box containing lists of customer orders and status. What I need help on is when users choose customer order with status "C" then the font in the combo box for this customer order is red, else will remain black.
How can I do this? I tried using conditional formatting but it won't work.
Thank you... -
weekdays calculation
Could someone please help.... ? below are my code on how to create indate and outdate.
...Code:If Not IsNull(rst2.Fields("Days_Required")) Then days = rst2.Fields("Days_Required") End If enddate = rst2.Fields("FinalDate") -
Unsecured workgroup database
Hi,
Is there a way for me to take off workgroup on access database? I have access 2003 that was created using workgroup and the person creating the database didn't leave me any admin password when he left the company. Now I have to make changes to the database and can't do it since I don't have permission. How can I make changes to the database or if I can add myself as admin to the database? (The database only have 1 admin user and... -
thank you for the reply. I'll try it and will let you know.......Leave a comment:
-
Can someone help me on this please.......Leave a comment:
-
yes it's in group footer. But I if I use the sum, it still will give me the duplicate invoice total. what I need is, if invoice # is duplicate, take off the duplicate invoice amount when I want to do the sum....Leave a comment:
-
sum in access report with repeating invoice
Hi I need some helps in calculating the invoice amount in access 2003 report. Basically I have an access report that shows invoice#, invoice amount, payment amount, and payment date. The problem is some customers paid 2 - 3 times for 1 invoices (different amount and date) so when I total the invoice amount it duplicated since the report will show the same invoice amount for 2 payments
for example:
invoice number invoice... -
I found out what's going on. There's an error on the ms access driver on that specific computer. What I need to do is recreate the ms access driver and that's solved the problem....Leave a comment:
-
Thanks for the reply. I did delete the link to that specific computer and relink it again, but the records still 20212. I can't open the table through the database it gave me an error saying "odbc call failed", but when I tried creating the query for the count, it gave me the records still 20212. The records should've been 20290. I updated the MDAC. Should I reinstall access 2003?...Leave a comment:
-
Missing data???
Hi,
I have a weird problem. I have an access database (in access 2003) with a link table from SQL called log with total records 20290. The problem is some computers show the whole record on the database, some don't. It only shows 20212 records. How is it possible since they're sharing the same database? how to fix this problem? Please help !!!! -
Thank you for all your help. but the code that you gave me is still not working (probably I'm missing something) Here is what I did: On the query (that showed all the data on the subform) on the partID criteria:
...Code:Like "*" & [forms]![frmsearch]![txtid] & "*" or Like "*" & [forms]![frmsearch]![txtid] & "*" and on the description criteria, I put: Like "*" & [forms]![frmsearch]![txtdesc]
Leave a comment:
No activity results to display
Leave a comment: