Help
in [Access]
|
Importing Excel spreadsheet into Access problem I'm using both Excel 2000 and Access 2000. A spreadsheet file (.xls) has been successfully imported into an Access database and it shows up in the Table list. And query against it returns results as well. But then when I copy this database to another directory. Open up the copied database and imported table d... 17 Mar 2010 18:38
Access 2007 Time format - Sports Lap timing and calculating I have a database I am starting to create. I need some guidance in how to best create a time format for a "sports watch". What I need to record is minutes:seconds:hundredths, however the times will need be manually inputted or imported. There will also be basic calculations performed on times e.g car a time for ... 15 Mar 2010 00:15
A2010 Release date May 12th, per this link http://blogs.msdn.com/access/archive/2010/03/12/access-2010-release-date.aspx ... 14 Mar 2010 22:04
Access 2007 training by TrainSignal-Any good? Hello, I'm looking for video instruction on Access 2007. Is the package marketed by TrainSignal helpful? Can anyone recommend a video based upon experience? I am new to Access but experienced with computers.Thanks. ... 15 Mar 2010 00:15
Syntax Error (missing operator) I'm using the DCount function in VBA. I need some other pair of eyes to locate my problem in the WHERE clause portion. Below is one statement of the code: rec2("PR") = DCount("[PN]", strProgram, _ "([PROC] = " & "BUYIH" & " Or [PROC] = " & "BUY" & " Or [PROC] = " & "BUYDS" & ") AND ([PO#PR] Like " & "G" ... 19 Mar 2010 20:07
Sorting bill of materials references In a bill of materials table I have references like C1, C2 ... C10, C11..C100 etc. Sorting the ref. field looks like this C1 C10 C100 C11 ... C19 C2 C20 C21 ... How to make it C1, C2 ... C9, C10 .... ? Best regards Lars P. Magnussen ... 15 Mar 2010 15:47
Printing Checks from Access I need to print checks from an Access 2000 database (can be updated if needed). If someone is doing this, can you share information on how you handle the fonts (check text versus the micr fonts at the bottom of the check), check alignment and text to words conversion. ... 13 Mar 2010 11:56
Reports, very slow to open I had an existing report but very slow to open. This is a payroll program. Here's what I did. On this report will display all the employees by branch. Then on each employees, I made two sub reports contains their earnings on the left side and deductions on the right side. It runs without problem but very slow. And... 14 Mar 2010 03:18
Nedd a little guidance on a data capture scenario from Oracle Hi Everyone, I am trying to decide how to approach a design problem. The scenario is that there is a data warehouse using Oracle that contains 'real- time' data that is needed for a report. The source data in the warehouse is messy to say the least, but with enough time wasted I have managed to get a clean 'capt... 16 Mar 2010 04:39
Allow Zero Length property I generally set this to true for all fields other than fields that I specify as required. Considering the default value is false I am wondering if it is a good or bad practise to set it true? ... 14 Mar 2010 01:13 |