Search results

I am system administrator for a small, very rigid call handling database. I want to know if there is any way I can find out who is logged into my database at any time (live check). The database runs from a .mdb file but there are no tables in the database that I can find where this info is...

Is it possible to display the user name used to log on to windows on a form? I have used the following code to get the machine name to display - but some machines are old and have new users..... Private Declare Function apiGetComputerName Lib "kernel32" Alias _ "GetComputerNameA" (ByVal...

Does anybody know of a site where you can download/modify/use pre-made databases files? I am looking to create a basic database to store survey details about signage on site for 200 sites. Details i need to include are Site, Sign, and Components.... I think the database itself would be fairly...

sorry, this may sound really dumb - but how do you query the MSysObjects table? Can you please give me an example...

I am trying to change a text field (that has been used to store Dates) into a date/time field so that I can sort it correctly However, when I try and change the data type, It gets to about 90% on the progress bar then tells me that my system does not have enough memory available, and that an...

Ok, Im still having no luck in getting this to work so I have attached a cut down version of the file so that you can have a proper look... Just to recap: The table Tbl_Temp_Update (cut down to save size) contains a Site_Area_Code field, which currently read HR1, HR2 etc - this needs to be...

Ok, well a very experienced Access programmer has given me the following code, Private Function retpc(v) As String retpc = IIf(Asc(Mid(v, 2, 1)) >= 48 And Asc(Mid(v, 2, 1)) <= 57, Left(v, 1), Left(v, 2)) End Function Public Sub asd() Dim sql$, rs As New ADODB.Recordset, cn As New...

I know this is a pain, but is it possible to select the left 2 charactors ONLY if they are letters, not numbers? For example, east london post codes are like "E4 7UH" or "E17 5TH" so I would want these to return "E" But northampton post codes are "NN3 6EU" so I would want them to read "NN"

Not sure if this is the way im explaining my objective incorrectly, but i think I should try again I have 15,000 sites that all have a post code, and a HR area code. I need a query that will look at each sites individual post code, and (in the same field - Site_Area_Code in table SCSite)...

The problem I have isnt that i cannot create the update query, but more that I do not know how to use wildcards within a query. For example, I want the query to look at the table with new regions (see below) and if the postcode BEGINS "AB" then change the HR2 code to NR1 ID Post Code New Region...

ok, well I got this to work, but it was so simple that it seems something may not be right.... I simply used the SQL: INSERT INTO SCSite SELECT * FROM tbl_Import; where tbl_import was my excel spreadsheet template with new sites on. If there are duplicate values it simply ignores them and...

I have a list of sites (approx 15,000) that I need to update. Basically, against each site we store a region code (HR1 - HR7) and we have decided to increase the number of regions we operate with. I have created a spreadsheet that states the post codes included in each new region (NR) and now I...

I am creating a small Access application that will allow me to update my Call handling system's site table. It uses an mdb file, and I wish to add new sites (from new contracts) to the SCSite table. I recieve regular updates of new sites from existing customers, so want to create a simple macro...