Home > Microsoft Access Help
Microsoft Access Help
Microsoft Access forum discussing questions and answers for the Access database. MS Access is used to handle small to medium database needs.
Access file size getting to big
My file size is getting larger and larger because of all the Forms and Reports. I was thinking, would it be a good idea to segregate the Interface stuff from the Database itself. What do you all think? Has anyone try doing something like th...
My file size is getting larger and larger because of all the Forms and Reports. I was thinking, would it be a good idea to segregate the Interface stuff from the Database itself. What do you all think? Has anyone try doing something like th...
answer(8) view(484) status(
)
)
can't see relationships
i create relationships in access 2002, save, close and reopen the database, but i can't see them.... however they work fine... i don't remember that happened in access 2000 what may cause this ???
i create relationships in access 2002, save, close and reopen the database, but i can't see them.... however they work fine... i don't remember that happened in access 2000 what may cause this ???
answer(4) view(763) status()
)
Creating a default Form
Creating a default Form that will Maximized across the screen when Access is opened. I have no idea if this is even possible, or would I have to twick it like in Excel. And how would I go about doing it.
Creating a default Form that will Maximized across the screen when Access is opened. I have no idea if this is even possible, or would I have to twick it like in Excel. And how would I go about doing it.
answer(2) view(32) status()
)
Lookup field returns wrong column in report
I抦 sure there is a relatively straight forward explanation for this but I am having a lot of difficulty with one of my reports. The situation is this; I have a main table that is populated with data from a lookup that references another tab...
I抦 sure there is a relatively straight forward explanation for this but I am having a lot of difficulty with one of my reports. The situation is this; I have a main table that is populated with data from a lookup that references another tab...
answer(1) view(372) status()
)
using CASE in MS Access select query
Hi, I'm using 2 tables A & B. The structure is a: emp_id, name, value, check b: emp_id, name, value check field in table A is yes/no field. Question: An sql query which can, If check= 'yes' pull record from table B else...
Hi, I'm using 2 tables A & B. The structure is a: emp_id, name, value, check b: emp_id, name, value check field in table A is yes/no field. Question: An sql query which can, If check= 'yes' pull record from table B else...
answer(1) view(145) status()
)
Referencing a Module object within a query
Hi I have built a database whose primary fuction is to track future staff movement and resourcing. The database runs a query based upon the variable [DateField], and requires the inputing of a value for [DateField] i need the query t...
Hi I have built a database whose primary fuction is to track future staff movement and resourcing. The database runs a query based upon the variable [DateField], and requires the inputing of a value for [DateField] i need the query t...
answer(1) view(679) status()
)
Fixed formatting plz Help!!
I am writing a .net application with an access 2000 data store. My code creates a table on the fly, I have a field that needs to be 11 characters long and right justified, if I manually enter Fixed in the fields format property box it wo...
I am writing a .net application with an access 2000 data store. My code creates a table on the fly, I have a field that needs to be 11 characters long and right justified, if I manually enter Fixed in the fields format property box it wo...
answer(1) view(761) status()
)
Nolock
Is there a way to specify no lock when constructing a sql statement to execute on an Access DB? I have some statements causing major locking probs in a linked table. Quote: SELECT Referrals.Auditor, Referrals.1, Referrals.2, St...
Is there a way to specify no lock when constructing a sql statement to execute on an Access DB? I have some statements causing major locking probs in a linked table. Quote: SELECT Referrals.Auditor, Referrals.1, Referrals.2, St...
answer(1) view(975) status()
)
Problem updating access database through localhost website
Hello, I am running Windows XP Professional on my PC. I have a web application that I'm developing locally on my machine. This applcation makes inserts and updates to my Access 2000 database. This functionality works fine when I uploa...
Hello, I am running Windows XP Professional on my PC. I have a web application that I'm developing locally on my machine. This applcation makes inserts and updates to my Access 2000 database. This functionality works fine when I uploa...
answer(1) view(659) status()
)
Show tabels in an ASP website
Hi! Can anyone help me with code to get all tabels in an Acess db.? Best reg Gert
Hi! Can anyone help me with code to get all tabels in an Acess db.? Best reg Gert
answer(1) view(982) status()
)
checkbox on form
hi, i have a form with checkboxes. how can i update the values of both the checkboxes and the textfiled in my tables??? what i need is that if i check on the checkboxes, a text box will appear besides it so that the user can type i...
hi, i have a form with checkboxes. how can i update the values of both the checkboxes and the textfiled in my tables??? what i need is that if i check on the checkboxes, a text box will appear besides it so that the user can type i...
answer(18) view(603) status()
)
Merging regional date formats...
Problems with merging dates in non-US format Hello! Quite a basic query (hopefully) but one which is causing us some headaches! It has been posted before by different people in several places, but all the solutions thus far have been...
Problems with merging dates in non-US format Hello! Quite a basic query (hopefully) but one which is causing us some headaches! It has been posted before by different people in several places, but all the solutions thus far have been...
answer(0) view(967) status()
)
Access jet sql vs. MSDE
Hi, What is better to use? Is it true, that MS no longer intends to develop jetsql?
Hi, What is better to use? Is it true, that MS no longer intends to develop jetsql?
answer(1) view(124) status()
)
Urgent Help Needed
I'm no expert in MS Access. My boss asked me to knock up a database to record all those who have done the mandatory Health & Safety Briefings. So I knocked up the field headings as so: Surname Passed test? ...
I'm no expert in MS Access. My boss asked me to knock up a database to record all those who have done the mandatory Health & Safety Briefings. So I knocked up the field headings as so: Surname Passed test? ...
answer(7) view(840) status()
)
Find last price paid...
I have a need to lookup all products purchased by a particular customer and the last price paid. I am running Access 2002 database. I can easily build a query and report to show all products and all purchases, but I am drawing a blank on ho...
I have a need to lookup all products purchased by a particular customer and the last price paid. I am running Access 2002 database. I can easily build a query and report to show all products and all purchases, but I am drawing a blank on ho...
answer(1) view(308) status()
)
ODBC call failed- Error
Hi all, I have replicated a DB (Access 2000 DB application using SQL Server 2000 as backend)and when i open the database and click on the drop down boxes on the forms i get a error message saying: "ODBC-call failed [Microsoft][O...
Hi all, I have replicated a DB (Access 2000 DB application using SQL Server 2000 as backend)and when i open the database and click on the drop down boxes on the forms i get a error message saying: "ODBC-call failed [Microsoft][O...
answer(0) view(822) status()
)
Alpha / numeric sort
Hi, I have a column that has values like: AU-10, AU-8, AU-9, AU-10A, AU-10AA, AU-11, AU-12, AU-12B, B-11, B-11C When i sort them using order by I get the result as: AU-1 AU-10 AU-10A AU-10AA AU-11 AU-12 AU-12B AU-8 AU...
Hi, I have a column that has values like: AU-10, AU-8, AU-9, AU-10A, AU-10AA, AU-11, AU-12, AU-12B, B-11, B-11C When i sort them using order by I get the result as: AU-1 AU-10 AU-10A AU-10AA AU-11 AU-12 AU-12B AU-8 AU...
answer(5) view(722) status()
)
Skip nulls in Paramarray
I am using the Excel Min function in Access with Paramarray to capture the parameters. It works OK if all of the parameters have non-null values but errors if any of them are null. How can I skip nulls? I thought to concatenate any non...
I am using the Excel Min function in Access with Paramarray to capture the parameters. It works OK if all of the parameters have non-null values but errors if any of them are null. How can I skip nulls? I thought to concatenate any non...
answer(5) view(321) status()
)
Between Dates in Query
I have linked via ODBC connection to some DDF files from our production software. I am trying to make a query that will limit the records to only the current year. I have tried using the "Between DateAdd("m",-9,Date()) And ...
I have linked via ODBC connection to some DDF files from our production software. I am trying to make a query that will limit the records to only the current year. I have tried using the "Between DateAdd("m",-9,Date()) And ...
answer(2) view(125) status()
)
Date Problems
Hi all, I am using front end as Access 2000 and backend as SQL Server 2000. The forms are written in VB. I have a field titled birthdate(selected the short date option), but whenever i enter the birthdate as 1924, it gets stored as 2024 ...
Hi all, I am using front end as Access 2000 and backend as SQL Server 2000. The forms are written in VB. I have a field titled birthdate(selected the short date option), but whenever i enter the birthdate as 1924, it gets stored as 2024 ...
answer(1) view(61) status()
)
Windows API calls
I need to have a button on a form initiate an executable using the "shell" command, then "wait" for the executable to complete, and then (and only then) begin some processing. The executable is an external (non-access...
I need to have a button on a form initiate an executable using the "shell" command, then "wait" for the executable to complete, and then (and only then) begin some processing. The executable is an external (non-access...
answer(2) view(235) status()
)
form displays recordset incorrectly
using ms access 2000, I have a form(VB) that when it displays a record using the find/replace function, it displays properly however, the record locator at the bottom of the form stays on the previous record messing up any updates. I'm ...
using ms access 2000, I have a form(VB) that when it displays a record using the find/replace function, it displays properly however, the record locator at the bottom of the form stays on the previous record messing up any updates. I'm ...
answer(9) view(497) status()
)
mail merge
hi, can anyone tell me how do i go about creating mail merge. pls advice nono
hi, can anyone tell me how do i go about creating mail merge. pls advice nono
answer(18) view(241) status()
)
check field
hi, i need help in combo boxes where i allow the user to enter the primary field in it for searching purposes. how can i check if the field is empty??? pls advice thanks! nono
hi, i need help in combo boxes where i allow the user to enter the primary field in it for searching purposes. how can i check if the field is empty??? pls advice thanks! nono
answer(1) view(617) status()
)
shift+enter in adp project with Access 2000
How can we disable the shift+enter keys in a adp project with Access 2000 so that when its being executed with these keys , won't open the database window as well Thanks in advance
How can we disable the shift+enter keys in a adp project with Access 2000 so that when its being executed with these keys , won't open the database window as well Thanks in advance
answer(1) view(199) status()
)
How display/edit html text from table field?
I'm storing the verbose details of web store products in my inventory table. How do I let user see/edit this without the html tags confusing them? Do I call FrontPage or some other html editor? Or insert this html from the table field...
I'm storing the verbose details of web store products in my inventory table. How do I let user see/edit this without the html tags confusing them? Do I call FrontPage or some other html editor? Or insert this html from the table field...
answer(0) view(443) status()
)
Can't assign value
I have form with several text boxes that are populated by a procedure called from a combo box from which the user makes a selection. I want to create a Cancel button to undo any unsaved changes to the text boxes so I have copied the foll...
I have form with several text boxes that are populated by a procedure called from a combo box from which the user makes a selection. I want to create a Cancel button to undo any unsaved changes to the text boxes so I have copied the foll...
answer(2) view(310) status()
)
Executed in Access 2000 or Access XP
I want , if exists one function in Access , that can return if a program is executed with Access is in Access 2000 or in Access XP Thanks in advance
I want , if exists one function in Access , that can return if a program is executed with Access is in Access 2000 or in Access XP Thanks in advance
answer(1) view(504) status()
)
MS access mdb file could not be found error
I have the following issue with my clients database... I set up the database on the server. Front end on the client machine. Linked the front end to the server using the linked table manager. Created a desktop shortcut to the front end....
I have the following issue with my clients database... I set up the database on the server. Front end on the client machine. Linked the front end to the server using the linked table manager. Created a desktop shortcut to the front end....
answer(2) view(736) status()
)
script
Is there anywhere i can get a script or an example thereof by which you may populate supporting tables (ACCESS) with initial values rather than enter them all in every time it is restarted? odd secenario yes, but it is so that the develo...
Is there anywhere i can get a script or an example thereof by which you may populate supporting tables (ACCESS) with initial values rather than enter them all in every time it is restarted? odd secenario yes, but it is so that the develo...
answer(4) view(296) status()
)
Programming
Home -
About Infoqu -
Contact -
Privacy Statement -
Link to Infoqu -
Bookmark Infoqu
Copyright 2007-2008 by Infoqu. All rights reserved
Copyright 2007-2008 by Infoqu. All rights reserved