Search results

Hi, Namliam kindly gave me some code to test for the name of the server that a pc is connected to. Unfortunatley our computers don't need to be connected to the network for us to log in. They still use an NT server login screen with name, password and domain name. They seem to store all...

Hi all, Is it possible to test if a computer is connected to a network? To make it clear i will have no prior knowledge of what is on the network. The only fact is that it will be running a windows server application. Any help greatfully recieved. Cheers Chris

Hi all, Tried a search but can't use IP as it's to short so here goes. Is there a way of getting the IP address/some other unique identifier of a computer through VBA? Cheers Chris

Hi Is it possible to connect to a computer on a network that is not a server i.e. I wish to "push" data onto a laptop from a database on a server. I know this is not the usual way round but it is for security reasons. Cheers Chris :confused:

Hi, For my latest DB i am developing an easy to use synchronisation routine. Part of the system updates FK fields. Currently i'm using a SQL Update query. Ideally i would like to simplfy this in the following way. 1. Pass Table name and Primary key field name to function. (Can do that.) 2...

Hi, Can someone tell me if this is possible. I want to use a table in an unlinked database in an sql. It is possible i could link the table to the database but i would rather not. I've tried the following but i get an error saying TblHub is not recognised. Am i mistaken in thinking that the...

Hi, I've written an encryption algorithm that requries the multiplication of 2 large (32+ character) integers. say IntA and IntB My problem is i need to retain the indivdual characters that are created by the muliplication of IntA and IntB, the programme uses the 1.0^X notation as soon as i...

Hi I have an unbound subform whose sourceobject changes. I need to pass the subform as a variable to a module. To complicate matters slightly i have a main form with an unbound subform as well. Forms!FRM_FRAMES!FRAME_2 main form and unbound subform Frame_2 then takes the form with the...

Hi For reasons best left unsaid i am trying to change the recordsource of an unbound subform from a button on another unbound subform. mainform = Frm_Frames Subform = FRM_AUDIT_MENU subform called FRAME_1 Subform = FRM_SELECT_AUDIT subform called FRAME_2 Simply, i collect an SQL string from...

Hi This is a little complicated. I have had to create a table of Rules that are translated via code into dates and times. I.e staffid, first monday after start of month , 09:00 , 11:00, location 2,rule#. would create a record containing the staffid , date of the first monday in the month and...

Hi Thanks to Len Boorman for his previous help with this we went through this recently and came up with the following ( i'll take responsibility for any balls-ups!) Basically . I want to be able to create a unique work shift that allows mutliple staff members to be assigned to each shift but...

Hi My brain is being reduced to the consistency of cream cheese today (way to hot :cool: and tired :o ). I'm trying to develop a Rota system for a hospital department and i've got to the point of trying to store the actual data that makes the Rota. My intention was to create a table of...

Hi Mile/ anybody I'm using the Active-X calendar control that Mile posted on a number of occasions. I was wondering if it is possible to limit the days available for selection. Basically i need a start and end date and i don't want the users to be able to select a start date that's after...

Hi I am trying to use a combobox to create 2 entries is a table. The first entry is simply the selected item from the combobox, the second is created as follows Private Sub CMBO_OPERATOR1_AfterUpdate() Dim rst As DAO.Recordset Set rst = Me.RecordsetClone Me.Bookmark = rst.Bookmark If...

Hi Not sure what's going on here. I have a tabular form with 2 comboxes CmboX and CmboY. CmboX gets its row source from TBL_X and CmboY from Tbl_Y. In the rowsource query for the CmboY i have put the criteria that if the value in cmboX is <=3 then display only records 1,2 and 3 from...

Hi I've got to deliver a db tomorrow. I was just doing some tiding up extra comments etc when i started to get the error message when opening the main form. Microsoft access can't find the tool bar '60' As it turns out one of my subforms wouldn't display as well, so i tried adding it again...

Hi Does anyone know if you can create a control, say an textbox, on a form without it being in design view. i.e if i click a button on a form the textbox is created. Cheers Chris

Hi I'm having a thick day today. I'm doing a project tracking db and i need help on a query for an update display. Basically i have 4 tables Project: ProjectID ,Desc .... ProjectModule: ModuleID, ProjectIDfk,Desc.... ProjectItem: ItemID,ProjectModuleIDfk,DateID,TimeID,UserID... User...

Hi I'm trying to resize an array as i go through a loop. This is how i have dimensioned the array Dim ColData() As Variant then to start the array (ColNow is an unknown value) Find ColNow then ReDim ColData(ColNow,0) then with each iteration of the loop ArrayInty is increased by 1...

Hi Does anyone know if there's a way of determining what control the cursor is currently over without using any of the events of the control itself. --more details-- What i have is a help file that is a form with the background set to a picture of part of a complex paper form. The user is...