Search results

I need to know how I can find how many seasons have lapsed between two dates. It's fairly easy if the 2 dates fall within the same year but I cannot figure out how to do it if they fall in different years. Following is how seasons are defined: season 1: 12/20-3/19; season 2:3/20-6/19; season...

I have a text box that accepts special characters. In order to type these characters, I have to use key combinations (from 2 -5 key combinations), for example, ALT + 1234. IS there any way that I can create a 2 key combination/shortcut for this? For example, instead of typing ALT + 1234, is...

I have a database that used to be on a network drive but I was always getting a disk error (the other users as well) everytime the database is left open and not do anything. To isolate the problem, I decided to transfer it to my local drive. I haven't been getting any errors and the db seems...

I have a form that contains 2 subforms, 2 command buttons,an unbound text box and another text box , testid=[subform1].[Form]![datesid]. Subform1 is linked to Main Form by the unbound text box and subform2 is linked to main form by text box testid. both subforms are in datasheet view. table1...

I have an Access97 database which will be converted into a MySQL db. I know it is possible to convert the backend db into a MYSQL db and that the Access db frontend can be linked to the MySQL server through ODBC. My question is, what would be the process if the db needs to be accessed from...

I have a field that displays url in a report like this: http://www.webaite.com/personal/page_title.jsp In some records, this field tend to be very long. I am just wondering if the URLs can be trimmed without editing each one. Is there a way that would tell Access to show only a part of text...

I can change the forecolor of a control on got/lost focus but I have to rewrite the code over and over for each control. How can I do it in a function? I tried using the activecontrol property but I don't have any luck to make it work. Thanks in advance for any help.

I have an ubounded text box in my report that contains a formula like: [text1] & [text2] & [url] When I preview the report, a # are appended at the start and end of url. I tried to have a separate text bos for url and it showed fine. I want to do it this way (concatenate) in order to save...

I would like to create a function that will take numbers as inputs and generate a certain combination of 5 letters. Let's use A,B,C,D,E for example. a user inputs how many A's or B's and so on, he wants to have in the output. It is not necessary that there is an input for every letter. So, a...

I have the following that shows me which record I am curently viewing out of total records. Dim Myrst As Recordset Me.CurRec= Me.CurrentRecord Set Myrst= CurrentDb.OpenRecordset("SELECT field1, field2 FROM tbl1 WHERE tbl1.field1='" & Forms!frminfo!field1 & "'") Myrst.MoveLast Me.totalrec =...

I found the Microsoft QBF sample and edited it. I am getting a Syntax error in one of the lines I added and wondering if it is really possible to do it. The error happens in the line that has the datediff function. I would like to be able to enter something like <=30 or >=30, etc. in the...

I would like to create a database that will keep track of documents being handed off from one person( or department) to another. I thinking of setting up an events table that will show the info about the document, who received it, to whom it was passed when and other info. However, I only want...

How will I be able to compare a current record with the previous record using rst?

I have a table that looks like this: SID..Field2(y/n)..Field3..Marker(Y/N) 1....-1...........85......0 1....-1 ..........21......0 1....-1...........12......0 1....-1...........28......0 1....-1 ..........15.....-1 1.....0...........21......0 1.....0...........13......0...

I need some ideas on how I would create a budget variance report. I am a bit confused on how I would start it. I have 2 tables, transactions and budget tables. Records would contain Account numbers, date of transaction, and amount. I need to create a report that will show the accounts, MTD...

I tried to use the code in MS's Article :How to Create an audit Trail of Record Changes in a Form. It does not seem to work in subforms. What should I do?

I have a report that takes its parameters from a form. I don't have any problem generating the report.When I try to click cancel (cancel button, on unload event, there's a macro to cancel event) or close the form without generating the report, the query associated with the report still executes...

I have a table that looks like this: SID Field2 1 1 1 1 1 2 2 1 2 1 3 2 3 3 3 1 4 1 5 2 5 2 My problem is, I want to get the SID if and only if its value in all occurences is 1, regardless of how many...