General
in [Access]
|
How to convert General date in julian date If the date is in an actual date/time field, you could display is like you wish in a query, form, or report with somehing like: CLng([FieldName]) However you are going to run into problems with the DD-MM-YYYY date format. debug.Print CLng(#13-05-2010#) = 40311 (13-May-2010) debug.Print CLng(#12-05-2010#) ... 27 May 2010 18:10
Version Updates Sorry for repeating this - previous question was in the wrong forum. I am writing an application in Access 2000 which travelling employees will load onto their laptops. As they do not have the Access program loaded, they will use Runtime. I anticipate that revisions will be needed over time. Updates might be... 29 May 2010 13:34
Eliminating Dates based on a measure Hello, I receive a file from our IT Department each month called tblHBI that has the following fields: Month (i.e. 5/1/10, 6/1/10), Measure (Falls. Infection Control, MRTs) and TotalCount. There are seven measures. The file has the sum of counts by measure for the past two years. The file runs through Decembe... 27 May 2010 18:11
Create Linked Mailbox for All Users in External Domain Hi I have several domains that they are separate Forrest One of these domains installed Exchange server 2010 Between all the domains I've created as a one-way trust How can I use the commands that all users are in other domains they have linked mailbox in my Domain and used Exchange there is a Command to create ... 27 May 2010 19:18
Hide or Disable Add New Record Button Have your custon 'add button' set the alloweditions to true when it is clicked and then set it to false once it has finished doing the add. -- Dorian "Give someone a fish and they eat for a day; teach someone to fish and they eat for a lifetime". "Dee" wrote: Could someone tell me what the vba code is t... 27 May 2010 18:10
Many (City) to Many (Zip Code) help I'm using Access 2007. I'm trying to design a many to many relationship. 3 tables, 2 fields per table: tblCities = ID(pk), City tblZipcodes = ID(pk), Zipcode tblCitiesAndZips = CityID(fk), ZipcodeID(fk) I have created 2 one-to-many relationships. I want to see all 327 combinations of cities and zip codes. ... 31 May 2010 08:41
Douglas Steele, Arvin Meyer, Tony Toews, John Spencer, Duane H I'm bummed... since I've got this part-time Access dev job for the past couple of years, I've made many great apps that make life easier for so many in our org, and it's due to this site and the many MVPs and others that have supported this site. When I needed help making something work, I came here... when I ... 30 May 2010 23:01
Access 2010 very slow with Sharepoint 2010 working with access 2010 is so slow, every table to open (Sharepoint) and query (even in design mode) takes a long, long time. what could this be? ... 28 May 2010 20:23
Calculating dates based on two dates from 24 hours I have two dates in my database. I need to start to write and track a report from the second date 24 hours after the first date. I need to report on the time frame it takes to return packets. They are supposed to be returned in a 24 hour period. ... 27 May 2010 18:10
How to construct a hierarchy from a list? (Access 2003) Greetings, Using Access 2003, my objective is to turn a list like this: Asset ID | Parent Asset ID 1 | NULL 2 | 1 3 | 2 4 | 3 Etc... Into a table like this: Asset ID | Parent 1 | Parent 2 | Parent 3 | Etc... 1 | NULL | NULL | NULL | 2 ... 30 May 2010 23:01 |