I am using a database to collate and send staff holiday requests to their Line Manager.
At the moment when the member staff selects their name their Line Managers name is automatically added as ...
[Tags: No tags defined yet] - Be the first to Tag this threadAdd TagsCancel
*Note: Tags must be comma (,) seperated. For example: boardtracker, forum search, search engine
Hi all,
I am trying to pull some data from an Access database based on whether a field value is 1 or 0 (yes or no, ticked or unticked). I have built the query and the correct data is selected....
[Tags: No tags defined yet] - Be the first to Tag this threadAdd TagsCancel
*Note: Tags must be comma (,) seperated. For example: boardtracker, forum search, search engine
Dear all,
Please advice on how to extend our database Oracle9i database to another physical disk (NetApps)
Oracle server runs on Windows2003.
...
[Tags: No tags defined yet] - Be the first to Tag this threadAdd TagsCancel
*Note: Tags must be comma (,) seperated. For example: boardtracker, forum search, search engine
Hello everybody;
I just want to ask the best technique in server-client database application. I developed just like a teller's client Application (POS).
My current setup:
I have SQL se...
[Tags: No tags defined yet] - Be the first to Tag this threadAdd TagsCancel
*Note: Tags must be comma (,) seperated. For example: boardtracker, forum search, search engine
hello guys,
im stuck in making a client server based database application using vb6 and sql. is it possible and easy to do??can anyone please upload such a project jst demonstrating the basic wa...
[Tags: No tags defined yet] - Be the first to Tag this threadAdd TagsCancel
*Note: Tags must be comma (,) seperated. For example: boardtracker, forum search, search engine
I have a table that is imported from a file using code I didn't write. The Table Structure uses text fields, but the values are numbers(Commodity prices). Is there a way that I can convert the fi...
[Tags: No tags defined yet] - Be the first to Tag this threadAdd TagsCancel
*Note: Tags must be comma (,) seperated. For example: boardtracker, forum search, search engine
Hi guys,
This is the really big frustration I had so far using Access 2007, I converted all the applications I created in Access 2K3 to Access 2007 because of the free deployment feature, since I ...
[Tags: No tags defined yet] - Be the first to Tag this threadAdd TagsCancel
*Note: Tags must be comma (,) seperated. For example: boardtracker, forum search, search engine
hi please help.how write the query abs((attendmatch.timediff)-(employee.Workhours)and <>(employee.category='Restday') AS Diffhours
i want to get the Diffhours result abs((attendmatch.ti...
[Tags: No tags defined yet] - Be the first to Tag this threadAdd TagsCancel
*Note: Tags must be comma (,) seperated. For example: boardtracker, forum search, search engine
HI all,
I have a crosstab query that counts the number of times each of a list of activities has been entered for every user, like this:
User act-1 act-2 act-3 etc
Dana----3
Joh...
[Tags: No tags defined yet] - Be the first to Tag this threadAdd TagsCancel
*Note: Tags must be comma (,) seperated. For example: boardtracker, forum search, search engine
Hello,
Simple question, looked but cant find anything on this, I have an invoice form and the detail subform, I have put an unbound field to sum all my details amount. This works fine, I have a ...
[Tags: No tags defined yet] - Be the first to Tag this threadAdd TagsCancel
*Note: Tags must be comma (,) seperated. For example: boardtracker, forum search, search engine
I've a website developed in ASP.NET that is connected to various tables and queries of an access file. The first page of the website has a drop down that gets populated with the data from one of t...
[Tags: No tags defined yet] - Be the first to Tag this threadAdd TagsCancel
*Note: Tags must be comma (,) seperated. For example: boardtracker, forum search, search engine
Hi:
Haven't use MS Access for a while.
I just create a query called qryAppendDate, how can I call in my vba code.
Something like: docmd.runquery ????
( I created the query by using "Crea...
[Tags: No tags defined yet] - Be the first to Tag this threadAdd TagsCancel
*Note: Tags must be comma (,) seperated. For example: boardtracker, forum search, search engine
Morning all
I've had a problem with my main data entry form.
The form is directly linked to the table - there's no coding trickery or queries.
I have a duplicate record button which is the default...
[Tags: No tags defined yet] - Be the first to Tag this threadAdd TagsCancel
*Note: Tags must be comma (,) seperated. For example: boardtracker, forum search, search engine
Hello, I have a sample database I had found and wanted to change one thing. It keeps track of how many days a person had taken a "Vacation" in the current year. I would like to do a simi...
[Tags: No tags defined yet] - Be the first to Tag this threadAdd TagsCancel
*Note: Tags must be comma (,) seperated. For example: boardtracker, forum search, search engine
Hey guys,
I have an access 2007 frontend interfacing with an access 2003 database.
Both the front-end and the backend are in 2003 format, but I split it
originally with 2007. Anywho, ev...
[Tags: No tags defined yet] - Be the first to Tag this threadAdd TagsCancel
*Note: Tags must be comma (,) seperated. For example: boardtracker, forum search, search engine
I think there is a module/utility that can be associated with an Access database so that the end users will not need Access installed on their PC's to run the database.
I have seen it done, I ju...
[Tags: No tags defined yet] - Be the first to Tag this threadAdd TagsCancel
*Note: Tags must be comma (,) seperated. For example: boardtracker, forum search, search engine
Hi all
I am having a bit of trouble trying to restrict table data using a date . I am using Microsoft Access, an OleDbConenction and OleDBCommand along with a Datagridview. My code is as follo...
[Tags: No tags defined yet] - Be the first to Tag this threadAdd TagsCancel
*Note: Tags must be comma (,) seperated. For example: boardtracker, forum search, search engine
I want to use the lookup facilty when I enter peoples names into an access 2003 database - just to save having to type out names all of the time. Does anyone have a complete database of common fir...
[Tags: No tags defined yet] - Be the first to Tag this threadAdd TagsCancel
*Note: Tags must be comma (,) seperated. For example: boardtracker, forum search, search engine
Here's the situation:
I have data broken down by state (39 state tables). Each state's field list is slightly different as follows:
each state has a different number of fields
all states will hav...
[Tags: No tags defined yet] - Be the first to Tag this threadAdd TagsCancel
*Note: Tags must be comma (,) seperated. For example: boardtracker, forum search, search engine
Hello all,
Why is it when I enter data into my subform it prompts me with a message stating its read only.
There are no queries, both main & sub forms have "Enabled" set to yes &...
[Tags: No tags defined yet] - Be the first to Tag this threadAdd TagsCancel
*Note: Tags must be comma (,) seperated. For example: boardtracker, forum search, search engine
Hi All
I'm trying to add a record to an MS Access table. The following code gives me the error "Object reference not set to an instance of an object." :-
Code:
Dim c...
[Tags: No tags defined yet] - Be the first to Tag this threadAdd TagsCancel
*Note: Tags must be comma (,) seperated. For example: boardtracker, forum search, search engine
I am trying to set up a database to track devices my company manufactures, the fixtures used to test them, equipment used with the fixtures and programs that run the fixtures, among other things. ...
[Tags: No tags defined yet] - Be the first to Tag this threadAdd TagsCancel
*Note: Tags must be comma (,) seperated. For example: boardtracker, forum search, search engine
I am working on some code in vb.net that will run periodically to update a sql2005 database table.
table structure is very simple.
tblserver
Servername (Keyfield)
item1
item2
e...
[Tags: No tags defined yet] - Be the first to Tag this threadAdd TagsCancel
*Note: Tags must be comma (,) seperated. For example: boardtracker, forum search, search engine
I have a .mdf database file I would like to view. The file is from another system. I need to install so I can debug the program that uses it.
Thanks.
...
[Tags: No tags defined yet] - Be the first to Tag this threadAdd TagsCancel
*Note: Tags must be comma (,) seperated. For example: boardtracker, forum search, search engine
Hello All,
I would just like to let it be known that I am very new to Access. I have spent the last 3 weeks going through a crash course with F1, the internet and anyone I can find. So I will be...
[Tags: No tags defined yet] - Be the first to Tag this threadAdd TagsCancel
*Note: Tags must be comma (,) seperated. For example: boardtracker, forum search, search engine
Browse sub-categories 
