Determining Computer Region/location
Jul 14, 2005Anyone know of a way in Access/VB to determine what the region/location is set to on a user's computer? Need to determine whether to use commas or decimals as a monetary separator.
Thanks,
B
ADVERTISEMENT
Determining A Forms Location (when Form Is Not Current)
May 31, 2005Greetings. :)
I am trying to position opened forms so that they are cascaded on the screen. I have discovered the movesize action (for the DoCmd) and Move property of a form (for Acc 2002/2003). However, if the application is opened up on different monitors (e.g.; 17" or 19"), the relative location of the opened form is not the same (i.e.; on the bigger monitor the opened form is too far over to the right and too high).
What I want to do is ...
When the subsequent (or second) form is opened up I would like to find the absolute location of the first form (always centered). This way I will be able to reposition the second and third forms relative to the first form.
Is this possible?
I'm having trouble referencing the first form from within the second form. The first form is still open, but they are not linked forms (not parent/child). I've tried:
forms("firstformname").left
forms("firstformname").top
but this does not work.
I've gone to online help and I've looked around in the newsgroups. But can't find any info. Anybody out there will suggestions?
Regards,
SueB :confused:
Countries,state/province,region
Mar 3, 2007Do you know of any knows list that contains cross-refs of all Countries,state/province,region so that I can build cascading combox for my site.
This is very strange. It is a concept we see all over the internet websites, but the least documented!!!!
Determining Tables Etc. Used By .adp
Sep 7, 2005I have an .adp file but I'm not sure which tables/mdb file(s) are used. Any easy way to determine this? I'm backward engineering because someone got fired. Any help would be appreciated.
View 1 Replies View RelatedDetermining Focus
Jan 4, 2007Is it possible to use the "On Lost Focus" event to determine which control now has focus?
View 6 Replies View RelatedCalendar, Code And Determining Value
May 8, 2006Working on a calendar project. I've found some helpful code, but I don't want to use someone elses whole project. So while trying to understand how all this works I'm running into some problems. I am using to start one of the simpliest codes I have found.
```````````````````````````````
Private Function filldates()
Dim curday As Variant, curbox As Integer, Tbox As Variant
curday = DateSerial(Year(Me![FirstDate]), Month(Me![FirstDate]), 1) 'first day of month
curday = DateAdd("d", 1 - Weekday(curday), curday) 'back to sunday
For curbox = 0 To 36 'need to loop thru 36 textboxes
Me("D" & curbox) = Day(curday)
Me("D" & curbox).Visible = False
Me("T" & curbox).Visible = False
If Month(curday) = Month(Me!FirstDate) Then Me("D" & curbox).Visible = True
If Month(curday) = Month(Me!FirstDate) Then Me("T" & curbox).Visible = True
curday = curday + 1 'nextday
Next curbox
End Function
```````````````````````````````````````
'Note' I have added the "T" box for additional info.....
My problem is this...... I have 36 boxes that can contain variable dates. What I want to do is on the "Click" or "DoubleClick" event of say...... box "T14" I need to determine what date is the current value of "T14" and then I can open the other form to that date. This other form would be details of whatever date is currently in "T14"
Does that make sense???? Hope so! :)
Any thoughts??
Thanks
Curtis
Determining Appropriate Const MaxRecords
Jun 7, 2005I have an ASP / Access storefront, connecting through JET OLE, which is frequently crashing with '800040005 System Resource Exceeded'. The whole ODBC/Jet service must be restarted by my host manually.
Usually this error indicates an unclosed rs.open. I have however triple checked all code and there are no unclosed loops.
I am examining the basic connection variables and wondering if perhaps as my database has grown over the last year, the following original 'out of the box' settings are no longer suitable, and causing this error.. in particular maybe the 'Const MaxRecords' is no longer enough (or is too many?). How does one calculate what these Const settings should be?
Thanks for any help!
Code:Response.Buffer = TrueConst adEditAdd = 2Const adCmdText = 1Const adCmdTable = 2Const adOpenForwardOnly = 0Const adOpenKeyset = 1Const adOpenDynamic = 2Const adOpenStatic = 3Const adUseClient = 3Const adLockPessimistic = 2Const adLockOptimistic = 3Const maxRecords = 200
Modules & VBA :: Determining New Month And Run A Procedure
Aug 6, 2013I've been stumped for the past couple of days trying to discern a method for a form to determine that it's a new month and run a procedure and only run it on month change.
My initial thought is:
Open recordset
move to the last record
compare the month in a date field within the last record to the current month
and run the procedure if the month is different.
I can't get this to work however and I'm not sure what I'm doing wrong. To be honest I typically fumble my way through VBA when it comes to opening recordsets. Here's what I got:
Code:
Dim rs As DAO.Recordset
Dim db as CurrentDB
Dim strSQL As String
Set rs = CurrentDB.OpenRecordset("FlightLog")
strSQL = SELECT [txtDate] FROM [FlightLog]
[Code] ....
txtReqNumb and txtFltNumb are the values to be reset at the beginning of each month.
Am I on the right track and just have the VBA wrong?
General :: Determining The Values In One List Based On Another
Jun 27, 2012I have a table with a few Listbox options. I want one of the columns' values to be determined by the value chosen in another field. How do I do this?
Example: In column A I choose value ABC from the dropdown. I want column B to now offer values in that list of DEF, GHI, JKL. If I chose XYZ in column A instead, I'd want the column B list to show MNO, PQR, STU. Etc.
Modules & VBA :: Determining If Another Form Is Loaded In Add Mode
Feb 2, 2014I have two related forms.One is a list of transactions and the other is used for both inquiry and adding new transactions. If the Inquiry form is just sitting in Add mode and the List form tries to open it in Edit mode, it won't open. Is there a way I can tell from the List form that the Inquiry form is in Add mode and either close it or tell the operator about the issue?
View 1 Replies View RelatedUrgent: Determining SQL Server User Name & Group From Access
Oct 17, 2005I have designed an application in Access with an SQL backend.
How do I determine the user logged into SQL from within my Access application.
Specifically what stored procedures can i use to determine
1. The user name
2. The user's group(s)
of the currently logged-in user.
I would appreciate any other techniques for solving this problem
Thanks.
Peter.
Nigeria
Modules & VBA :: Determining Number Of Users Of Split Database
Nov 1, 2013We have a database that is split. Every user has their own front end (installed via a .bat file so that the users always have a local copy of the most recent version), linked to a shared back end on a server. This seems stable and functional for us so far.
However, because our users are geographically separated, I don't actually know how many folks are using the database. I know the folks who contact me, but everyone in our company could use it if they wanted to.
For requesting funding, guiding future development, etc., I need to get some metrics:
Total number of unique users
Avg uses per day
Total number of simultaneous users (daily, weekly, and monthly maxes and mins)
What is the best way to get this info? Write user info and a timestamp to a table each time a front end is launched? Are there tools for monitoring this sort of information?
Determining Actual Running Time Of External Application In Access
May 3, 2014I want to run an external application (a batch file) ... and want to run it by clicking on a command button on a form. That part is all fine, using the Shell command. I can determine the start time of the application (also fine with now() function) .. but want to find out how long the external application ran and log that "run time" into my database.
The part I don't know about is the .. really the ending time. How do I determine how long the application really ran for / ended ? I imagine I can use datepart to determine the difference in the start and end times. Or would I use a timer control. (but I cannot find the timer control in Access 2010).
Computer Name Or ID
May 27, 2006Anyone know how to get the computer ID or name unique to your computer?
I want to be able to use it in a database to keep logs for each computer on the network.
Any ideas?
Please Help My Computer And Me
Dec 3, 2006Hi
I don't know ASP at all, and I know very little about the Internet.I do know JavaScript and VB6 among other things, so I am not a complete dummy.
I have a webpage on a webhosting company's ftp (they host asp) and my html file is working, but my asp file won't do anything (should I be calling it with the javascript from my html file?).
What I want to do is make a list of the top 10 players of a game.
My questions:
1. how do i get my asp to display anything?
If I use my winXP IIS I can view ASP files. But from this ftp the computer just asks me if I want to run the file or save it and then opens my interdev program. Please help before I throw this computer out the window and I don't get to see your message.
2. Should my access file be 2.0 or 7.0 or whichever?
3. I use this code (from a tutorial) to connect to a database,
but it doesn't work.
[code]
<%
Set Conn = Server.CreateObject("ADODB.Connection")
Conn.open "DSNname"
%>
What is DSNname?(In VB6 it is the name of the data control), but there is no such thing here, is it the mdb file name?
I think I will have many more questions but for now I'll stop here.
Thanks
My.Computer.Filesystem
May 19, 2005After 2 days of searching I am sick too my stomach from not finding what I needed. I simply do not understand how it is possible that everyone, including Microsoft, assumes people just know stuff.
I have been wanted to read text files within an Access DB. The DB will extract key words and store them into fields. This is all very simple if I could get the rotten VB to read the files. I wanted to use the object My.Computer.FIlesystem, and all the others associated with that library. But going through the hundreds of possible references, I haven't a clue to which one has that library.
No matter where I went too look, not a single line, post, page listed how to reference it. Only how to use the function. So frustration.
My current reference list is as follows:
Visual Basic for Applications
Microsoft Access 11.0 Object Library
OLE Automation
Microsoft DOA 3.6 Object Library
Microsoft ActiveX Data Object 2.5 Library
If someone can please help.
Help Computer Crashed
Mar 31, 2006Can anyone help i was in a database and my computer crashed now when i try to load the database it says it needs to be repaired so i click yes to repair it and it comes up Could not find Description how can i fix this
View 2 Replies View RelatedComputer Database Help
Jun 14, 2006I am building a database of all the computers at the company i work for. Each computer has a unique ID. I want to be able to enter the ID of a computer and have its details displayed. IE. A user enters 34321 and then computer 34321 shows up and has information about its history specification etc.
Where do i start?
Cannot Open *.mdb On New Computer??
Jul 29, 2007I want to transfer and old database used currently for quotes etc to a new computer. I transfered all files, but when I want to open the file an error message comes up referring to the old location on a small office network. How can I import, that is use the files on new computers??
Thanks! You help is greatly appreciated!
Deed, Auckland, NZ
Migrate To Another Computer
Mar 24, 2008I have a small lookup app working fine on one computer. When I copy the files to another computer, it does not recognize the search entry as having a value.
What have I missed doing?
Thanks
How Can I Check Which Computer Is In Use
Oct 13, 2006Hi,
I made one database. Inside the database, I want to make a screen that show that which computer is in use of the current database.
Can we do that? Does anybody know how to do?
Thanks.
Sync With Computer Clock
Jan 18, 2006Hi,
My question is...is there any way to get Access to work out the actual day of the week from a date entered into the computer? The reason for this is...I am designing and implimenting a bookings data base for a village hall, and I wish access to automatically store what day of the week it will be on the specified date, in a field called 'Day'. I need this field to produce a report for the week ahead, showing exactly what is in on which day of the week. Is there any way this can be done? Or do the days just have to be typed in manually, i.e. check a calendar and type them in? I would appreciate it if anyone could give me info...on ANY way this can be implimented...be it store the dates in a table or use a giant Iif statement or whatever! And the tags necessary would be helpful,
Thank-you for your help in advance, and i apologise for such a lengthy post!
Please get in touch directly through c.majury@ntlworld.com or alternatively post the answer here.
Chris
Computer Configurator - How To Add Prices Together?
Feb 20, 2006I am trying to create an Access database that can be used to configure computers for sale in a small pc repair shop.
What i need it to do is have drop down boxes for different parts, each part having a value, and at the end being able to update the total value depending on which parts are selected.
I have tables with different types of CPUs, Motherboards, RAM, etc etc... each table has description and price values ( a couple more for relational stuff but i don't think that is needed to figure this out ) Just to test it out i have a form where i can go through and select the different products, but i am stuck on the adding of values of the different computer parts.
So anyway, i am trying to take prices matched with values from multiple tables, then add the prices all together at the end for a total value, like any of the pc configurators online.
If anyone can help, greatly appreciated, if i make no sense just ask to clarify...
james
Computer Identification - Security
Apr 11, 2006In my Frontend, i use parameters like:
1) computer name
2) a certain file's existance
So i'm sure that the front end is being run on an autherized computer.
i have hardcoded these values in the vb code and password protected the project so that no one knows about it.
what other parameters can i use to stop the front end being run from any other computer else than thoses allowed.
Computer Booking Form
Sep 30, 2006Hello,
For work i need to create a computer booking form so that people can book out computer rooms 2 weeks in advance and the perminant bookings are always in there etc etc... most of it i have sorted but what i want is for a query that can run and go to todays date and then only bring up the results for the next 2 weeks.
Is there anyone that could help me out with doing this because im at bit of a loss and its doing my head in :confused:
Any other comments or suggestions are welcome too if there is a better way of doing this.
Thanks, ieuuk
Automatic Computer Name Info
Jan 24, 2007How would I get Access to autopopulate a table's text field with the user's computer name when they enter data into a form? The user shouldn't have to enter this...
View 4 Replies View Related