PHP and MS Access Database
I'm trying to access an access databse located in my LAN thru php. When I run the script, I get the below error in Apache's error log file: "[strong]PHP Fatal error: Uncaught exception 'com_exception' with message 'Source: Microsoft OLE DB Provider for ODBC Drivers Description: Operation was...
I'm trying to access an access databse located in my LAN thru php. When I run the script, I get the below error in Apache's error log file: "[strong]PHP Fatal error: Uncaught exception 'com_exception' with message 'Source: Microsoft OLE DB Provider for ODBC Drivers Description: Operation was...
5 pts.
To trap the item name of more than one item selected in list control
1)Is it possible to trap the item name of more than one item selected in the list control?Then how?I wish to trap the item name of more than one item selected in the list/combo control with/without the help of index numbers of the item selected. 2)And then use this item name to pick up data related...
1)Is it possible to trap the item name of more than one item selected in the list control?Then how?I wish to trap the item name of more than one item selected in the list/combo control with/without the help of index numbers of the item selected. 2)And then use this item name to pick up data related...
Database being auto duplicate when exit.
hi you, i've created a database for my dept and place it on shared server. The problem is everytime user exit from the database, there will be a duplicate of database at the server. Example: my database file name is correspondence_log.accdb, when user finished used the database, there will be an...
hi you, i've created a database for my dept and place it on shared server. The problem is everytime user exit from the database, there will be a duplicate of database at the server. Example: my database file name is correspondence_log.accdb, when user finished used the database, there will be an...
Erro in Subform in Ms Access Reports
Hi All! I have a question that i have designed a report in ms access and I put a subform and linked it with the Party Group, I have put vb codes to use calculate some values if value on subform is null then VBA debug for error, I have used below all function but not solution is there: NZ(), Val(),...
Answer Question
| Nov 15 2009 7:34 AM GMT
Microsoft Access, Access reports, Microsoft Access subforms
Hi All! I have a question that i have designed a report in ms access and I put a subform and linked it with the Party Group, I have put vb codes to use calculate some values if value on subform is null then VBA debug for error, I have used below all function but not solution is there: NZ(), Val(),...
Answer Question
| Nov 15 2009 7:34 AM GMTMicrosoft Access, Access reports, Microsoft Access subforms
Access 2007 IIF statement in query criteria
This is a query design looking at a checkbox on a form, if its checked, I would like to return only the database fields (ConfigData) that contain text. If it isn't checked, return all the fields whether they have text or not...Pretty basic filter I thought Seems like I'm getting close but can't...
This is a query design looking at a checkbox on a form, if its checked, I would like to return only the database fields (ConfigData) that contain text. If it isn't checked, return all the fields whether they have text or not...Pretty basic filter I thought Seems like I'm getting close but can't...
Access Form Printing Problem
I have designed a set of forms in Access. One of the forms prints the form in total. However tow of the forms will only print the header and footer and does not print the data input portion of the form. What am I missiong in regards to why I can't get these two forms to print in total? Thanks...
I have designed a set of forms in Access. One of the forms prints the form in total. However tow of the forms will only print the header and footer and does not print the data input portion of the form. What am I missiong in regards to why I can't get these two forms to print in total? Thanks...
Migration from Paradox to MS Access or VB.Net/MS SQL
We have a department that has several applications running on Paradox 11. They need assistance migrating their tables and application UI/code to another platform. Any feedback or guidance would be appreciated. Software/Hardware used: Windows XP desktop, Windows Server 2007
We have a department that has several applications running on Paradox 11. They need assistance migrating their tables and application UI/code to another platform. Any feedback or guidance would be appreciated. Software/Hardware used: Windows XP desktop, Windows Server 2007
COMBO BOX (IN VB) HOW BEHAVE LIKE MS ACCESS
HI VB EXPERTS, PLEASE SOLVE HOW CAN BEHAVE THE VB COMBO JUST LIKE MS ACCESS COMBO (OFFICE 2003/2007) EG. IN MS ACCESS COMBO :- A) WHEN START TYPING THEN NEAREST MATCHED SELECTED/DISPLAYED B) ON GOT FOCUS COMBO DROPDOWN ABOVE FACILITIES I WISH TO AVAIL IN VB COMBO BOX PLEASE PLEASE PLEASE ...
HI VB EXPERTS, PLEASE SOLVE HOW CAN BEHAVE THE VB COMBO JUST LIKE MS ACCESS COMBO (OFFICE 2003/2007) EG. IN MS ACCESS COMBO :- A) WHEN START TYPING THEN NEAREST MATCHED SELECTED/DISPLAYED B) ON GOT FOCUS COMBO DROPDOWN ABOVE FACILITIES I WISH TO AVAIL IN VB COMBO BOX PLEASE PLEASE PLEASE ...
VB
Hi Experts in VB 6.0 Please Tell me how I code for combo just like Access form eg. In Access Form's Combo -- when we start type any letter then nearest matching data should be selected and auto also showing during typing in the combo box Question : Please give any idea for VB 6.0 Combo --- so when...
Hi Experts in VB 6.0 Please Tell me how I code for combo just like Access form eg. In Access Form's Combo -- when we start type any letter then nearest matching data should be selected and auto also showing during typing in the combo box Question : Please give any idea for VB 6.0 Combo --- so when...
Master/Child Link problem in Subform
Hi, I needed to add a new table to my database, so I added it and created a one-to-many relationship with the parent table. I then created a form and used the subform wizard to make it into a subform. The Master and Child links are the primary key in the parent table and the foreign key in the...
Hi, I needed to add a new table to my database, so I added it and created a one-to-many relationship with the parent table. I then created a form and used the subform wizard to make it into a subform. The Master and Child links are the primary key in the parent table and the foreign key in the...
copy 1.2 GB mdb from pc to network
When copying 1.2 GB mdb from pc to network, it seems that the copy created in the network is corrupted although I am not able to tell by looking at the size of the file. Does anyone have an experience of copying a big mdb file from pc to network?
When copying 1.2 GB mdb from pc to network, it seems that the copy created in the network is corrupted although I am not able to tell by looking at the size of the file. Does anyone have an experience of copying a big mdb file from pc to network?
Forms in Access 2007
I am using a form to upload data from the form into a database. I have a submit button on my form that upon clicking, needs to input all the users data into the correct slots in the database but I have no clue on how to do this, or where to get started. How should I go about solving this problem? ...
I am using a form to upload data from the form into a database. I have a submit button on my form that upon clicking, needs to input all the users data into the correct slots in the database but I have no clue on how to do this, or where to get started. How should I go about solving this problem? ...
Access for Windows 5.4
On one of my PC that uses Access for Windows when I start the Display I also start the printer and it seems to blink the printer screen when starting. So times it just blinks and blinks and bli.nks. I loaded the latest fix, but it only happens on this one machine. Software/Hardware used: Access...
On one of my PC that uses Access for Windows when I start the Display I also start the printer and it seems to blink the printer screen when starting. So times it just blinks and blinks and bli.nks. I loaded the latest fix, but it only happens on this one machine. Software/Hardware used: Access...
Error 2282 in Microsoft Access
Hello all, I have a database that sends a report by email in pdf format automatically by pressing a button. My problem is that whilst this works perfectly on my computer, I get an error "2282 - the format in which you are attempting to output the current object is not available." on other users...
Hello all, I have a database that sends a report by email in pdf format automatically by pressing a button. My problem is that whilst this works perfectly on my computer, I get an error "2282 - the format in which you are attempting to output the current object is not available." on other users...
How do I set decimal places with VB Access
I am using Access 2000 database for calibration control of measuring instruments. i.e. micrometers, calipers etc. The precision of the instruments varies and the decimal data fields in the table are set to Auto to minimize the stored values without changing the accuracy. I want to change the number...
I am using Access 2000 database for calibration control of measuring instruments. i.e. micrometers, calipers etc. The precision of the instruments varies and the decimal data fields in the table are set to Auto to minimize the stored values without changing the accuracy. I want to change the number...
How to connect Forms 6i with MS Access
Can anyone help me in connecting the Oracle Forms 6i with Microsoft Access Database. Please send me an example also, so that i may be understood properly and clear my logics tooooo. Best Regards Rashid Shah
Can anyone help me in connecting the Oracle Forms 6i with Microsoft Access Database. Please send me an example also, so that i may be understood properly and clear my logics tooooo. Best Regards Rashid Shah
Date problem with Delphi 7
I am trying to select records where the date is smaller that a specific date by using Delphi 7. The data is stored in a MS access 2000 database. dtsdate.DataSet := qrydate ; qrydate.Active := false ; qrydate.SQL.Text := ' select * from datum where datum < 1994/02/05' ; qrydate.Active :=...
I am trying to select records where the date is smaller that a specific date by using Delphi 7. The data is stored in a MS access 2000 database. dtsdate.DataSet := qrydate ; qrydate.Active := false ; qrydate.SQL.Text := ' select * from datum where datum < 1994/02/05' ; qrydate.Active :=...
Write Recordset to MSAccess(mdb) using VB6.0
How can I create a new mdb file from recordset which is populated from oracle db. Please share any examples of writing recordset into mdb file. Thanks in advance. Software/Hardware used: VB6.0, MS Access 2003
How can I create a new mdb file from recordset which is populated from oracle db. Please share any examples of writing recordset into mdb file. Thanks in advance. Software/Hardware used: VB6.0, MS Access 2003
Capture SQL Server logged in db User name in Access 2007 Accdb
I have a SQL Server 2005 backend with an Access 2007 Accdb front-end application. Security has been established via SQL Server database user groups with associated table-level permissions. I would like to disable certain form functionality based on the logged in user. Is there a way...
View Answer
| Aug 24 2009 11:14 PM GMT
SQL Server 2005 security, Access 2007 security, SQL Server 2005
I have a SQL Server 2005 backend with an Access 2007 Accdb front-end application. Security has been established via SQL Server database user groups with associated table-level permissions. I would like to disable certain form functionality based on the logged in user. Is there a way...
View Answer
| Aug 24 2009 11:14 PM GMTSQL Server 2005 security, Access 2007 security, SQL Server 2005
Access Query - Repeating fields
I have a file of 70K names. Some are dups. I want to create a indicator in Access to flag when the name is repeated indicate 'Y' else 'N'. Any ideas on how to create a query to do this Software/Hardware used: Microsoft Access 2003
I have a file of 70K names. Some are dups. I want to create a indicator in Access to flag when the name is repeated indicate 'Y' else 'N'. Any ideas on how to create a query to do this Software/Hardware used: Microsoft Access 2003
