Recent content by mdbBound

Well, to the two of you. I came to this forum for help. Isn't that what this forum is for? Go back to your Mission, Vision, Values, Goals and Objectives and recall why this site was created. Confused? People who are not confused will not be so desperate that they spend valueable time to...

what can you say about this Mile? I need help on this Please.

Im just so in a hurry right now, but can you please rewrite the part I need to change to Dcount thanks

Urgent Please help! If Not IsNull(Dlookup... My goal is to findout if the record exist, open a form message, else, add the record. Please check my code. it always go on error when it reaches line 9. So from line 9 to line 19, does not work. Please urgent!!! Error message is "The...

Doug, thanks WLngNo is an autonumber that is formatted to come out this way. WStrNm field is the text version of WLngNo so I could join it with other tables later. This is the process: 1. There is a form. On the form, the user will click a button to get the next available number using this...

Need help on Dmax please! Critical I have the following scenario Table: testWLog. WLngNo field: has W001,W002, W003, W004 and W005 WStrNm field: has W001, W002, W003, W004 and W005 PreparedBy field: Default =environ("Username") has UserA (for rows W001 to W003). It Also has UserB (for...

Thanks, Pat

Thanks Pat, It's taken care of.

Thanks Mile,

Hi Pat thanks. My function returns a Long (it is the autonumber). I convert it to text or string when I show it to my form and also when I append/update it to a field in a table. These all works fine but I am just concerned about this Dmax scheme in a multiuser environment. By the way I...

Hi, What will happen to my modules, with functions and public variables when I split my database and in a multiuser environment? I have created 2 modules. One of them has functions to get the next available numbers. The other one holds the Public Variable names that i need to around my...

Please tell me what is wrong with the following code and how can i best accomplish the following. I a created a module (NextNum) with the 3 functions. I want to call these functions in 3 different forms. My goal is (1) to get the next available autonumber, (2)Convert that from Long to Text...

Thank you Kodo. You are very helpful. I certainly will mention all of this to the meeting. Sorry I don't mean to be repetative, but just to make sure I get this right: If I will use Access as a frontend and database server as backend wherein both must be installed in a web server or the same...

Appreciate all your insights. My boss is not so big on the idea of this becoming a web app however i will try to justify it. I think web app is the way to go. Users are 50% intranet and 50% internet. They are in downtown LA and in other cities. If this stays in Access, 1. where will the...

Urgent! I need advise please! I will create an Access database that will be accesible on the web. It will be used by 3 departments which are located in 3 different offices in downtown LA. Now, can Access do this? I'm worried about performance. The users should be able to view different...