ms-access

Is there any way to destroy MDW reference

Hi, I have an access 2003 file that someone secured with a mdw. However, that person isn't there anymore and the mdw file was lost. Can we do something, anything, to open and read that file ? Thank you ...

Check Microsoft Access Form Values before Save

I have an Access Form - lets call it "Add Labor" (Access 2007) that saves data into a table. The table has two columns in particular called "Start Date" and "End Date" (This table stores tasks) There is also another table called FiscalYears which includes Start and End Dates for Fiscal Years, which is structured as follows FyID FYear...

access 2007 a loop to loop through a particular textbox in one form

my problem is as follows I have a properties form which contains a textfield called DateTo(this textfield contains the data type Date) I would like to loop through the DateTo textfield on each of the properties and prints this out in a message box as wasll as a tenantName textfield and a tenantAddress1 field. After this is complete i w...

How do I revert to default System.mdw after doing a SetDefaultWorkgroupFile?

I am doing the following in code to set the default workgroup file: Application.SetDefaultWorkgroupFile "c:\myworkgroup.mdw" How do I find out what the current workgroup is before I do this so I can revert? Is there something built into Access? Thanks, Greg ...

proper way of updating sql server table using access front end

i have a front end in access and back end is sql server 2008 one of the fields is the account number and here are the rules it is a zipcode like 92111 plus a dash plus a number. so the first one would be 92111-1, the second 92111-2 this has to do with how many clients we have in the zip code i would like this zip code to be automati...

Select a value from a table in current DB and use a variable in Access VBA

In Access VBA, I want to use values from a "Settings" table, instead of hard-coding folder locations etc. in the code. I can't figure out how to load a value from the table and use it in the code. Dim oFSystem As Object Dim oFolder As Object Dim oFile As Object Dim sFolderPath As String sFolderPath = "C:\Documents and Settings\Main\D...

hyperlink data not transferring to destination table

I'm inserting records that includes a hyperlink field from 1 table into another that include a hyperlink field of the same name. In the source table, the hyperlink behaves correctly; however, when inserted into the destination table, it does not. The field displays the correct "hyperlink" (path) in the destination; however, it is not fun...

ms-access: is it possible to save an access form separately from DB?

i have a front end access with a bunch of forms and reports. i want to be able to save one of the forms by itself to its own file. how do i do it? ...

OpenOffice Base Report that takes user input.

Hi All, I'm working on a LOT of VBA code that generates reports from Excel. I reckon it's a really stupid idea to use Excel and VBA to run "queries" on an worksheet so I'd like to do it in a database environment. I successfully ported the required table and data into OpenOffice base. The problem now is that I need to run a report tha...

Make this report in one SQL in C#

EDIT: the database is Access 2007 Hi, I'm new here and I need some help: I have three tables: technicians (Id, tech_name, is_active) type_services (Id, serv_name, is_active) services (Id, date_time, prod_name, quantity, serv_type, tech_name, is_active) I have to make a report that contain: Number of services per tech (SUM(quantit...

select statement within selected days MS Access

I will have a table with datetime column Let's name it TmStamp with data 01/01/2001 01:00:PM there is another date column, Let's name it RegDate with data 01/01/2001 I want to select data with that date. So I write SELECT * FROM TABLE WHERE RegDate>=#01/01/2001# and RegDate<=#01/01/2001# I get data for 01/01/2001. HOWEVER, SELEC...

How can I solve this issue: "System resource exceeded"?

I'm using Access as a database in my asp.net project and I'm facing this error: System resource exceeded. Please guide me how to resolve this issue. ...

sql select - order by but partial part of the field

hi guys i want to use the order by catid... but i need to use it on the 2 letter of the catid field this is not working for me: order by mid(catid, 2,3) what can be the answer? ...

Import Lotus Notes Database into Access/SQL - What about Documents?

I have a few Lotus Notes 'databases' that i'd like to import into Access or SQL. I think I have most of the steps down (install NotesSQL ODBC driver, setup ODBC connection to Lotus DB, import data into Access), but I can't figure out what to do with all the documents, eg: Word Files, PDF Docs, Excel Workbooks that were in the Lotus DB. ...

is it possible to format the data before going into the DB?

i have an access front end for a sql server database my question is: is it possible to format/input mask the data in a datasheet before it goes into the DB? for example, if i want to enter zip codes into the database. is it possible to set the length in ACCESS to be only 5 digits? how about a phone number? ...

MS ACCESS SQL, MAKE TABLE change field type

Using MS ACCESS SQL, to MAKE TABLE with changing field type, which coding should be used? eg. a Character type field with data '0056.80' is wanted to be converted to numeric type 56.8 Help!! ...

Problems linking a subform to a combobox on the main form

On a form in an access ADP there is an unbound combobox that displays a list of companies (the name is shown, the id is the bound field). When a company is chosen, I want to display the subscription information in a subform (the datasource for which is companySubscription view) for that company. I set the link Master Fields and links ch...

adding a new column in SQL SERVER but it is not showing up in access

access is the front end and sql server 2008 is the backend i am opening the specific table in access. i have no problem editing data in this table using sql server and then displaying the changes in access; however, when i add a new field in sql server, the changes are not reflected in access. i am opening the table as a datasheet and ...

is there a simple front for sql server?

i am in a multi-user environment i am using access as a front end connecting to sql server database. i am allowing users to edit only one table in sql server. i dont want to continue using access to edit a sql-server table. can someone recommend another tool to do this? ...

MS Access Auto Link Excel Spreadsheets

I have a directory structure where I am managing the requirements of a system with each component of that system having its own directory. the requirements of each component are stored in a excel workbook that has multiple worksheets(# of worksheets are static). I am currently using access as a central location to view the information ...