Search results

Perhaps the most fundamental reason for using a database is to process names. Specifically, a process that can automatically parse a name into its constituent name parts and provide a method in which names can be populated into their proper places is a great time-saver. For instance, if you...

Sorry, deaf...I just saw your thread for the first time. Are you using Access 97? If it is A2K or greater, you can use the Split function. The split function creates an array variable (use variant for ease of use) that separates your text string into different elements. In your case, if you...

You would probably need to use a Top N query with a descending sort order in the pertinent field. For instance, if you have a table, Mytable, with fields called nameID, name, and salary, then you would create the following query to find the records with the top salaries. "SELECT TOP 3 * FROM...

Yes, there are some string functions to use. You can use this technique directly in a query or in a module using VBA. I'll do the VBA here. strFirstName="Johhny" strLastName="Goetz" strEmailName = Left(strFirstName,1) & strLastName & "@myemail.com" This returns "JGoetz@myemail.com". Check...

Try this: DateDiff("d", MyEarlierDate, MyLaterDate) + 1 NOTE: if the days are the same, then the answer will be 1.

If you need the decimal, then the following will work (given that there is no nulls) DateDiff("n",[TimeReported],[TimeDefectGiven]) / 60 This divides the minutes by 60, which gives you the hours in decimals, which is this case would be 1.5 . If you need a clock-like display (such as 1:30)...

Part of the confusion is that Access uses conflicting date formatting information, especially with regard to the Year and Julian date designation. For all examples, datDate= #March 1 2008# The first example will return the 4 digit year: Format(datDate, "yyyy") = 2008 The next example will...

What you want to accomplish is ***REALLY BAD*** database design. I really don't think I can explain what you should do in one post, but for starters you do not want to create fields for specific dates, no matter how many you have. You would accomplish listing reports in date groups by using...

The best solution would be to create a database on the fly, install the temp tables to that external database on the fly, then link to that database for your report data. Once the report is closed, you can use the close action to unlink the database, then delete the database. In addition, when...

Another solution is to create a new database, then import all the objects from the existing database using the "File | Get External Data | Import" menu option. When the selection box comes up, select the existing database, then click OK. The "Import Objects" form comes up. First, click the...

The field that the text box is referencing may contain Null data. Try the following: =Nz(IIf(Len([Ename])>0,(Left([ename],InStr([ename]," ")-1)),""),"") This means that if your text box contains null data, you will not get the error and instead replace it with a zero-length string.

(SumTotalMinutes)\60 gives you the total hours, while (SumTotalMinutes) Mod 60 gives you the total minutes. Format appropriately.

There have been a couple of examples in this thread that has provided a return of a date from an occurrence of a particular day of the week, such as "3rd Wednesday in Month" function earlier. The idea was to simplify the function to a tight algorithm so it could be used for any Day of Week, as...

When you create an Access Report with a subreport control, you can use VBA to format the Detail section to create alternating colored rows. Unfortunately, subforms do not share the same versatility as subreports. However, you can create rows of alternating colors by adding a field to the query...

Try doing the query again, but click the SUM button at the top of the query menu. It looks like an "Σ". Next, pick the fields Docno and Center. On Center, on Total change Group By to Max. Run the query. It should show you the data you are looking for.

First of all, you have to have an understanding at how Access manipulates Date and Time values. In a nutshell, the Date/Time datatype is actually a special Double number. This whole, or integral, number is determined by how many days have elapsed since December 30, 1899. The fraction...

OK, I was going by the assumption that you have the following: 1. A table called tblCode 2. Fields in tblCode that are called Code_A and Code_B 3. A requirement to transfer data from Field Code_A to Field Code_B Indeed, you see that it is an update query that I have posted. Now, I don't...

If this is an Excel chart formatting problem, you may have to set the chart up in VBA with the Excel object model. Can you do this?

Assuming table name of tblCode, use the following query: UPDATE tblCode SET tblCode.Code_B = tblCode.Code_A, tblCode .Code_A= Null;

Date serial WILL work with Excel VBA, but is not in itself an Excel function. But you are right that he should be checking references. I am guessing he's missing the Visual Basic or Applications reference, or the reference to his Access application (or particular Office application).