Search results for query: *

Hello All ... I am having no luck in the Access Modules section... Could anyone help me with this question regarding recordsets ??? thread705-391248 Thanxs a million ... Tiny ... PS I wouldn't normally double post, but I am in Need of some help... Perfection is Everything If it worked...

Hello All, I have a button on a form that populates a list box on the finding of a recortset. 'Start of process ... Dim DB as Database Dim SName as String Dim rstOne As Recordset Set DB = CurrentDb SName = "Joe Bloggs" Set rstOne = Db.OpenRecordset("Select FullName...

Hello All, Simple really... Problem: The problem lies in Excel 97 and what I want to do is code a button in a worksheet to close and not save the changes ... Why: I know it is bad practice but I have a large amount of VB code that runs several Pivot, Imports, stats analysis etc etc ... you...

hello all ... I have a problem ... why today of all days ... its friday ... My code ... Dim PatientDemogRst As Recordset Dim MstrRevAnalRst As Recordset Dim db As Database Dim thisdb As Database Set db = CurrentDb Set thisdb = CurrentDb GetPatientDemographics...

I have a simple Insert statement that does not want to run .. Dim dbs As Database Dim staff As String Set dbs = CurrentDb() Set order = Forms![frmOrder]![OrderNo] dbs.Execute ("Insert into tmporderList (OrderNo) value (Order);") I am new to VB and SQL and can't understand what...

This may be simple but I haven't a clue .. I have a buton that opens an excel spreadsheet.. simple enough! But the spreadsheet has a password on it I want access to to open the spreadshee and run the macro within the spreadsheet .. I have got the button to call the spreadshheet open it ...

Hello all ... Simple problem ... 2 check boxes on a form that the user must select at least once ... In the button a simple call procedure lets the form continue if the user has selected at least one of the check boxes .. Btn code: If CheckForm = False Then Exit Sub Else Function...

Has anyone come across a problem where an ActiveX control does not work on certain machines that have Access97 installed on them ... I have the ActiveX control on a form and 2 users out of 9 cant use the form as their version of Access cannot comprehend the ActiveX control... Is there a...

Has anyone come across a problem where an ActiveX control does not work on certain machines that have Access97 installed on them ... I have the ActiveX control on a form and 2 users out of 9 cant use the form as their version of Access cannot comprehend the ActiveX control... Is there a...

The problem ... I want to edit a record in a table depending what the user has selected from the form. There are three combo boxes: Name, Date and Attendance I need one button on the form that the user presses to update the attendance record that matches the criteria in the Name and Date...

Hello All ... I have a problem concerning a form, a table and some VBA ... The problem .... This form has an UserName field and two unbound fields, BeginDate and EndDate. Also on this form I have one button ... This button has to take the UserName from the form and append the records...

Problem is I have 100 lines of data in one table that is required to be changed daily by at least 6 users. I can let them see their data, but they also need to change this data. I need to record these changes within another table as a log. The criteria is that each record can be changed only...

Hi, I have created an online questionnaire which uses an AciveX slider. The problem is whenever a user clicks on the slider the value appears. I need to hide this from users but it still needs to exist as the value is then sent to a database using ASP. Can anyone help me please?!? Thanks Tiny

Hello How can I embed a vb Slider into a html form and get it to return a value when the user clicks on submit .. .. Basic VB and HTML programmer needing help!!! Regards, Tiny

I have a form which when opened runs a sub-form and the underlying query. How do I disable this on opening the form and only open it when required to do so via a button?

Simple One .. .. How do I round a number to 2 decimal places in a query within Access. Excel has Rnd() as a formula but Access doesn't allow it .. . Any suggestions?

Hello the wise ones .. .. I have a database that has Excel Spreadsheets imported into it for analysis. The spreadsheets are located on different network drives as they are correlated from multiple external sites. This central database has had very minimum security and I now need to make sure...

Very simple and quick one .. .. Developed a file locator database for a Project manager. The database is stored and used on her laptop but she has started to experience a problem .. The folowing message keeps appearing every time she goes into the database, she then exits the database and...

Thanks! cornerstone for the VB coding .. .. But .. .. Simple problem .. .. two forms - unbound fields adding data to three tables. If the detail, about to be added is already in the primary table, then I don't want to add the record .. .. Code from the form to add the details .. . Private Sub...

Fairly new and basic VB programmer ... I have a very simple problem .. .. I have two unbound forms with fields which users add data to. I then have 3 tables to which this data is split into .. .. using 3 append queries, the problem is, using a button on the second form I want the users to...