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.
How to compare rates quoted by contactors
By some processing of data in access 2003 i finally able to get different list of works to be done and its quantites through a query. Now I want to insert the rates of each work quoted by different contactors and finally to compare them. Plea...
By some processing of data in access 2003 i finally able to get different list of works to be done and its quantites through a query. Now I want to insert the rates of each work quoted by different contactors and finally to compare them. Plea...
answer(0) view(1) status(
)
)
msoFileDialogFilePicker Problem
I am currently developing a database for a client and am using msoFileDialogFilePicker to select a file. However I am experiencing a strange condition. When I display the contents of a folder as thumbnails, Access crashes with a memory erro...
I am currently developing a database for a client and am using msoFileDialogFilePicker to select a file. However I am experiencing a strange condition. When I display the contents of a folder as thumbnails, Access crashes with a memory erro...
answer(5) view(624) status()
)
Fuzzy Matching in Access
Hello All, For those who are interested in Approximate String Matching or those who could use these algorithms; I have a complete suite of Approximate String Matching algorithms written in Visual Basic in an Access database. In 2004...
Hello All, For those who are interested in Approximate String Matching or those who could use these algorithms; I have a complete suite of Approximate String Matching algorithms written in Visual Basic in an Access database. In 2004...
answer(45) view(1,730) status(
)
)
Organising large database
Hi I have a large database with many tables, forms, queries repost etc. These are stored named and displayed alphabetically, is there a way to place them in folders within access so it is easier to organise and locate as i am developing. O...
Hi I have a large database with many tables, forms, queries repost etc. These are stored named and displayed alphabetically, is there a way to place them in folders within access so it is easier to organise and locate as i am developing. O...
answer(2) view(776) status()
)
ADO error 800a01fb
Hi, apologies in advance if this is in the wrong forum... I've currently taken over administrating a server. Being new to ASP, I didn't realise the importance of closing connections/recordsets after using as I didn't think it was that im...
Hi, apologies in advance if this is in the wrong forum... I've currently taken over administrating a server. Being new to ASP, I didn't realise the importance of closing connections/recordsets after using as I didn't think it was that im...
answer(2) view(963) status()
)
use Option Group with check boxes
I want to insert an Option Group with check boxs to can choose more than one choice not one only but more in the same field , and appear in the table not numbers but text example : vaction days ( saterday - sunday - tusday .....) I c...
I want to insert an Option Group with check boxs to can choose more than one choice not one only but more in the same field , and appear in the table not numbers but text example : vaction days ( saterday - sunday - tusday .....) I c...
answer(0) view(40) status()
)
Conditional Input Mask?
Is there a way to create a "Conditional" Input Mask? Here is what I need: I have an Input Mask that reads "06-"999"-DE". This returns the desired entry of 06-123-DE in the assigned field. The problem is that...
Is there a way to create a "Conditional" Input Mask? Here is what I need: I have an Input Mask that reads "06-"999"-DE". This returns the desired entry of 06-123-DE in the assigned field. The problem is that...
answer(2) view(581) status()
)
Snapshot to word document
I have the following button on a form: When I press it a mail is being send with a snapshot attached to it Instead of a snapshot I want it to attach it as a word document. Here you see the code that is used. I noticed it sa...
I have the following button on a form: When I press it a mail is being send with a snapshot attached to it Instead of a snapshot I want it to attach it as a word document. Here you see the code that is used. I noticed it sa...
answer(3) view(850) status()
)
Single page form and mouse scroll wheel problem.
Is there a way to prevent a user from switching records on a single page form when he rolls his/her mouse wheel. I have noticed that users accidentally scroll the wheel, and this switches them to the next record. I need for them to re...
Is there a way to prevent a user from switching records on a single page form when he rolls his/her mouse wheel. I have noticed that users accidentally scroll the wheel, and this switches them to the next record. I need for them to re...
answer(5) view(736) status()
)
this code is missing something,it does`nt work ??!!
problem: when we go to new record the code not work so we add some update to that code to be : Public CurrentBookmark As String Public MouseWheelMoved As Boolean Private Sub Form_Current() On Error Resume Next If MouseWheelMoved = True Then...
problem: when we go to new record the code not work so we add some update to that code to be : Public CurrentBookmark As String Public MouseWheelMoved As Boolean Private Sub Form_Current() On Error Resume Next If MouseWheelMoved = True Then...
answer(0) view(35) status()
)
Have Combo Box Show First Item on List
I have made a few cascading combo-boxes that dynamically change based on the data entered into the field above them.. Example: A SKU is entered, the combo-boxes pull the information for that sku from one or more tables (using SQL Query). ...
I have made a few cascading combo-boxes that dynamically change based on the data entered into the field above them.. Example: A SKU is entered, the combo-boxes pull the information for that sku from one or more tables (using SQL Query). ...
answer(8) view(752) status()
)
how to capture weight from weighbridge thro windows API in oracle forms6i?
Please send codes?
Please send codes?
answer(0) view(42) status()
)
Read Comm Port (Serial Port)
I have soem code that is looking at the Comm port on my laptop....I had this code working great about 9 months ago. I dont know what has changed besides me moving to another laptop. I dont know if I am missing a reference to a llibrary ...
I have soem code that is looking at the Comm port on my laptop....I had this code working great about 9 months ago. I dont know what has changed besides me moving to another laptop. I dont know if I am missing a reference to a llibrary ...
answer(5) view(460) status()
)
Access Wizard crashes App
I have been having this issue with two different versions of Access, firstly XP and now 2003. The issue is every time I open a blank database, and click on the "create using wizard" option, access crashes while trying to set u...
I have been having this issue with two different versions of Access, firstly XP and now 2003. The issue is every time I open a blank database, and click on the "create using wizard" option, access crashes while trying to set u...
answer(6) view(742) status()
)
MS Access dilema
I'm sending an automated e-mail using the docmd, my problem is that the message i want to send spans the VBA design page and wraps onto the next page thus turning red and unusable, do's anybody know what i'm doing wrong and if so tell me so...
I'm sending an automated e-mail using the docmd, my problem is that the message i want to send spans the VBA design page and wraps onto the next page thus turning red and unusable, do's anybody know what i'm doing wrong and if so tell me so...
answer(1) view(883) status()
)
How can I pass a paramater to MS Access query through the command line
How can I pass a paramater to MS Access query through the command line " C:\....\MSAccess.exe C:\....\MyAccess_database.mdb "
How can I pass a paramater to MS Access query through the command line " C:\....\MSAccess.exe C:\....\MyAccess_database.mdb "
answer(1) view(448) status()
)
msaccess - query with time range
I have a table which contains data readings taken every 90 seconds. I need help defining a query that will allow me to report on instances of data being below a given level for a period greater than an hour, ie if the data reading only dro...
I have a table which contains data readings taken every 90 seconds. I need help defining a query that will allow me to report on instances of data being below a given level for a period greater than an hour, ie if the data reading only dro...
answer(1) view(158) status()
)
On Click
Hi, On one of my forms I need a button that when clicked on would update a field in a table. Is this possible? Thanks in advance Steve
Hi, On one of my forms I need a button that when clicked on would update a field in a table. Is this possible? Thanks in advance Steve
answer(1) view(804) status()
)
HTML Tags in Query Field
Hi, I have a databse that holds details on faults we have on our network, and a set of web pages to list all of those faults. When i add a fault to the database it adds it to the web pages itself.. i do this by using a macro to export...
Hi, I have a databse that holds details on faults we have on our network, and a set of web pages to list all of those faults. When i add a fault to the database it adds it to the web pages itself.. i do this by using a macro to export...
answer(1) view(455) status()
)
Hi access people!
Do any of you live in the UK? My teacher told you to ask this. I look forward to asking you lots of questions in the future. Tom
Do any of you live in the UK? My teacher told you to ask this. I look forward to asking you lots of questions in the future. Tom
answer(0) view(712) status()
)
Automatic Inclusion Of Csv
Hi I have been given the task to create a database for work to monitor the stock production and sales. I have very limited knowledge of access but the main headache is coming from trying to include csv's in the thing. As part of th...
Hi I have been given the task to create a database for work to monitor the stock production and sales. I have very limited knowledge of access but the main headache is coming from trying to include csv's in the thing. As part of th...
answer(0) view(183) status()
)
How to backup access?
Hello, I have a database at www.provencemaison.com I want to make a backup once a week orso. I dont want to use ftp programs. Is there a way I can create a sql script so I can rebuild the database when this is nessary? ASP and ASP.Ne...
Hello, I have a database at www.provencemaison.com I want to make a backup once a week orso. I dont want to use ftp programs. Is there a way I can create a sql script so I can rebuild the database when this is nessary? ASP and ASP.Ne...
answer(2) view(1,054) status()
)
Read Only
I am writing a database that will keep track of help desk calls. I have a couple different table that I am using (Employee, Initial Call, Finished Call, others). After the Inital call has been registered into the database I want to be abl...
I am writing a database that will keep track of help desk calls. I have a couple different table that I am using (Employee, Initial Call, Finished Call, others). After the Inital call has been registered into the database I want to be abl...
answer(1) view(761) status()
)
Add data to two tables.......
Hello all you nice folks out there in the nether regions of cyberspace. I have a issue in access that I could use help with. I am creating a database that is proving a little tricky... I have tables that list names if 'images' and 'm...
Hello all you nice folks out there in the nether regions of cyberspace. I have a issue in access that I could use help with. I am creating a database that is proving a little tricky... I have tables that list names if 'images' and 'm...
answer(2) view(308) status()
)
access query
Database has tables with: employee data (date, hours, ID#, location, equip ID, etc) vehicle data (equip ID, rate/hr, etc) personnel data (name, payrate) materials (location, # of items used, crew, etc) barricades (billings for barrica...
Database has tables with: employee data (date, hours, ID#, location, equip ID, etc) vehicle data (equip ID, rate/hr, etc) personnel data (name, payrate) materials (location, # of items used, crew, etc) barricades (billings for barrica...
answer(0) view(244) status()
)
Help - Email a Report
I designed my Form and my Report to look the same, to be user friendly. I've added an email button so when someone fills out the form they can send that report. The problem is that ALL records of the report are sent and it's only text...
I designed my Form and my Report to look the same, to be user friendly. I've added an email button so when someone fills out the form they can send that report. The problem is that ALL records of the report are sent and it's only text...
answer(1) view(120) status()
)
whats wrong with my query
This is a query created in access: SELECT Duiven.Rin, Vader.Rin, Moeder.Rin, VaderVader.Rin, MoederVader.Rin, VaderMoeder.Rin, MoederMoeder.Rin FROM (((((Duiven LEFT JOIN Duiven AS Vader ON Duiven.Vad=Vader.Rin) LEFT JOIN Duiven AS Mo...
This is a query created in access: SELECT Duiven.Rin, Vader.Rin, Moeder.Rin, VaderVader.Rin, MoederVader.Rin, VaderMoeder.Rin, MoederMoeder.Rin FROM (((((Duiven LEFT JOIN Duiven AS Vader ON Duiven.Vad=Vader.Rin) LEFT JOIN Duiven AS Mo...
answer(0) view(784) status()
)
lock Access Database
Dear All, what I need to do is the following:- 1) Open a table to insert a new record 2) Lock this table so there is no new entries in it 3) get the maximum call number and add 1 to it 4) insert the new record 5) Unlock the table...
Dear All, what I need to do is the following:- 1) Open a table to insert a new record 2) Lock this table so there is no new entries in it 3) get the maximum call number and add 1 to it 4) insert the new record 5) Unlock the table...
answer(2) view(817) status()
)
Date to String in SQL statement
Hi, I have to be able to execute an sql statement which would look something like this. SELECT * FROM Table1 WHERE start_date LIKE '*01*' The problem is this does not work since start_date is from the type date. How can I co...
Hi, I have to be able to execute an sql statement which would look something like this. SELECT * FROM Table1 WHERE start_date LIKE '*01*' The problem is this does not work since start_date is from the type date. How can I co...
answer(1) view(453) status()
)
am i doing something wrong?
hello i need a urgent help on database design, and on my relationship tables to be precise. i was doing an exercice on a small theater company where i have to keep a record of all the actors who are available to take part in a production a...
hello i need a urgent help on database design, and on my relationship tables to be precise. i was doing an exercice on a small theater company where i have to keep a record of all the actors who are available to take part in a production a...
answer(2) view(303) status()
)
Programming
Related Pages
- Query by Month
- Sort date formatted as year and week
- updating combo box from form launched in form
- open jet error
- Adding a record from a combo box
- Employee database
- Export from access to excel
- Help with Pop Up Form Field
- [VBA] Exporting a query(report) to Excel
- criteria for date field causing 'data type mismatch' error
Home -
About Infoqu -
Contact -
Privacy Statement -
Link to Infoqu -
Bookmark Infoqu
Copyright 2007-2010 by Infoqu. All rights reserved
Copyright 2007-2010 by Infoqu. All rights reserved