Search results

MSXML 4.0 comes with the Microsoft XML 4.0 Parser SDK which is quite comprehensive in definitions of XML, XML Schemas, the DOM and SAX. It also provides some sample code which can be easily modified. If you're comfort level in VB is relatively high, you shouldn't have a problem. The one main...

Access 97 and Access 2000 do not naturally support exporting or importing of XML files (I'm not sure about the morer recent versions). However, given that XML files are simply heirachical, well formed text files, it is not that hard to write a parser to do this for you. An excellent product...

Please only post your question to one forum. If you are uncertain which forum it belongs in, play it safe and place it in General. I have responded to your posting in the Forms forum. Cheers SteveA

Try the following: Private Sub Form_beforeUpdate(Cancel As Integer) If Not me.chkNew And Not me.chkRepair And Not me.chkChange Then MsgBox "Please Check one of the services", vbCritical Cancel = True End If End Sub HTH SteveA

Unfortunately, the DoCmd.OpenReport command doesn't allow you to pass the OrderBy criteria the same way you can pass a filter (to the best of my knowledge). However, you can place code in the OnOpen event of your report to retrieve these details from your form and sort the data before the...

There are a few things that could impact your design when it comes to tracking accrual. These include: * The type of interest are you wanting to track? Compound, Simple, Rule of 78 etc. * How the annual percentage rate is to be calculated ie 366/365, 365/365, 90 day bank bill rates * Are you...

Try If IsNull(rst![MyField]) Then ... Cheers, SteveA [This message has been edited by SteveA (edited 01-27-2002).]

If I understand correctly, the [Storage field] will always equal "Not Stored" if the [Box number] field is blank, and will always equal "Stored" if the [Box number] field is populated. If this is the case, you probably shouldn't store the field in your database. It would be easier to calculate...

Have you checked to see if the query is actually returning an updateable recordset. Try running the query by itself and see if you can make changes, and add or delete entries. If the query allows you to do this, try the following line: Set rstOrders =...

An approach that we have used in one of our databases as an interim solution was to set up a Custom Action in Outlook that calls our own VB program which: * interrogates the e-mail * updates the appropriate database * sends a reply to the sender advising action was successful, and * saves e-mail...

SMathews, The following code should do the trick. Pass the value you want validated into the below function and it will return true or false. I checked it against the Javascript version and received the same results, but haven't done a lot of testing. HTH SteveA Function checkABA(ByRef...

Another thing is to look at what your users are currently using and looking for common behaviour patterns between these applications. For instance, PF01 in most applications triggers online help. Making your help key PF07 would confuse users. If CTRL-P allows printing, don't block this in your...

The entry you keyed in was: Format(Nz(Parts,0)"Currency") The problem is that you are missing a , before "Currency"). The following should work: Format(Nz(Parts,0),"Currency") HTH SteveA

Using format(transdate,"yyyy") will create a field that holds the year of your date which you can then sort on. HTH SteveA

In your query, ensure that the only field from the parts table is the cost field and that it has a total property of Sum. Bring up the properties window of the query and change the UniqueValues property to Yes and the UniqueRecords property to No. HTH, Steve A

When you run the query, does a blank row appear at the bottom to allow you to add new entries? If not, then the relationships between your tables in the query may need to be changed to support the entry of new values (if at all possible). HTH SteveA

Your other option could be to set yourself up with a security workgroup and make your logon, the only member of the admins group. Create a new database and import all the objects. This should assign the ownership to yourself. Change the access rights for the admin logon to only be a member of...

You should be able to do the following: Private Sub Cycle_Records_Click() Dim stdocname As String Dim Rst As Recordset Set Rst = Me.RecordsetClone 'If there are records to process, continue If Rst.RecordCount>0 Then 'Move to the first record in the recordset Rst.MoveFirst 'Process each record...

If you are using Workgroup Security you can place =CurrentUser() in the default value field of the OperatorID field and it will automatically populate with the current users ID. HTH SteveA

The following should be okay: Change from: Me.Filter = "omschrijving = [Which category are you searching for?]" Change to: Me.Filter = "omschrijving Like '*' & [Which category are you searching for?] & '*'" I haven't tried it out, so please let me know if it doesn't work. Cheers, SteveA