Search results for query: *

Dear Experts, I am a novice VBA coder and been googling this w/o any luck. Can this be done? Let's say there's a mySQL server running on host: xyz.com DBname: myDB table_name: tblA (and login/pw etc...) Then there's local Access DB with the same table name/structure. Can they be...

Dear experts, How can I prevent a user from "copy" the whole datasheet by using "copy and paste"? For example, a user can easily "copy" a whole datasheet then paste it into excel sheet. Thank you in advance.

Dear Experts, I have a field which has some NULL values. When I sort this field ASC, (Let's say "fldA"), NULL values show up at the top. I understand I can make them listed at the bottom by using query - fldA Is Null DESC, fldA ASC. Is there anyway to do this by using Form's "OrderBy"...

Dear Experts, Here's my situation. Please parden me if this is too basic question... I have a table "tblName" as following: id name 1 David 2 Robert 3 Peter 4 Andy on table "tblRecord", those names are stored as number using combo box trick with bound column 1 but showing only 2nd column...

Dear Experts, I want to make the following code as "Global Module". However, I'm stuck with making "FormName" variable since it's connected with "Forms!". Any ideas will be appreciated. Thanks. BTW, how put following code inside a box? (Like many of you do nicely...) -------------------- Sub...

Dear Experts, Here's where I'm stuck: I have two forms: Form A, Form B both forms have same key - invoice number I have a pull down menu in each forms - cboInvNum I used macro on that PDM - GoToControl then findRecord to go to specific record on both forms. What I want is, when both forms A...

Dear experts, on a form A there are 1. txtRegDate (text box) 2. cmdToday (command button) clicking cmdToday will fill today's date on txtRegDate cmdToday has this event: me.txtRegDate = date Weird thing is this works on some forms and doesn't on other forms. the error msg is "Run-time error...

Hello, I always appreciate expert helps in this forum. Here's what I'd like to do with VBA coding: 1. Upon mde file open and switch board opens, check if a table is link to R:\tables.mdb 2. If not, un-link all current tables then re-link to R:\tables.mdb Thank you in advance.

Would someone please explain to me the differences between Me.txtName vs. [forms]![thisfrm]![txtName] also what's the difference between Me.txtName vs. Me!txtName I am really confused about using dot (.) and bang (!) it seems like both works the same?

Hello, I have a group "A". User "userA" belongs to group "A". I setup permission for the group "A" as following: "tblA" - pull permission At this point, "userA" doesn't have any permissions to "tblA" I thought setting permission to a group will be inherited to the users belong to that group...

OS: xp pro Office: XP I want to code following... If currentgroup = "manager" then open form name "frmManager" else open form name "frmOthers" end if I understand there's a function "CurrentUser()" to check current user. However, I couldn't find embedded function checking a user's...

I thought this was going to be easy but... so I have a form with this checkbox named "A", source..let's say A. Now, let's say there's a report with a label captioned as "A" (name is "LabelA") I want "A" to show up in the report when checkbox "A" is checked. (meaning value is true on a table)...

I have many tables with many unused fields(which don't have any data on it due to poor db planning) I want to use VB code to print the list so that I can show it to my manager to convince him that our DB table needs restructuring. Could you give me some pointers? for all tables on this db...

I have codes looking like followings. It is IF-THEN and While Loop. I have about 100 lines of code being repeated twice. (exactly same code) How can I make this simpler? I can use Function or Sub and pass variables but is there any other way to do this? Thank you so much for your time. Always...

Function Is Not Available In Expression In Table Level Validation Expression" This error comes up when Access tries to enter a new entry using DAO Recordset .AddNew. Very weird thing is some machines work fine with this. All of our office computers have Win XP Pro with Office XP installed with...

Hello, I'd like to do something similar to this...would someone please shed some light on me? Thanks in advance. if userid = userA then open form A else if userid = userB then open form B else if (..and so on) I guess we can use switch for this purpose. OS: XP pro Office XP

Thank you for helping me in advance. I took over this DB project just now and have questions about security. Here's the setting. secured.mdw on local machines db.mde on server (front-end) db_be.mdb on server (back-end) User clicks secured.mdw, then choose db.mde, type in log-in/pw. However...