I coded the following statement into my vb6 program using DAO. I do not get any error message syntax wise; however, the table value is not being updated for recurringJournalID. But as you can 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
I am using PivotCharts to graphically display my data. However, when I place the data into the chart it names the labels with the calculation (e.g. sum of X, count of X). How do I edit these? The ...
[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
The field looks like this:
DonorRange: LMBDonorRange(Sum([Donation]))
DonorRange being the field name. I understand the Donation field is being added together and put into the DonorRange field, b...
[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 just upgraded pc and copied files from disc to new pc
installed office etc... but now i am getting error message
id automation error and a problem with my date() functions
i have change...
[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
After deleting a few years of backup pieces, I have stretched out catalog tables.
Has anyone had success rebuiding (ex: move) the larger and now much more fluffy tables, like rc_backup_piece?
...
[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 all,
I'm working on a database that has data in four columns in one table. What I need to do is take that data, compare, then replace it with data from a single column on another table if 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,
I'm designing a database in Access 2003 to monitor and calculate staffing hours in our project. Time spent on certain activities is entered on a form in hh:nn format, in a Date/Time field, 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 see that we can create indexes on function output instead of column value, and I wonder if we can also do that with PKs..
Basically I have a 2 part PK.. One is based on a number, one is base...
[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,
I am a bit confused as i have a query which is a cross tab and i want to creat a report of it. Only problem is as its a cross tab the headings change all the time eg
April 2007, May 20...
[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 having a issue with a dcount not working properly.
The table is called tblMain
In this table is a field called clientid as text
I am delcaring a field in my database called client 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
How can I open two tables at once,
I tried this code but it didn't worked for me:
vb Code:
Dim rs As ADODB.Recordset Set rs = New ADODB.Recordset rs.CursorLoca...
[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 Gurus,
I need to alter the global temp. table but its not letting me alter it
and throwing the below error,i tried few times at regular interval but no use,is there a way to 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
Is there a way to step through a stored procedure, in a similar way to how you do with .NET source? Small procs aren't bad, but sometimes troubleshooting/debugging is a nightmare on larger procs....
[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 query that shows me my crewmembers training records. thanks to Tiro Cupidus and Khawmar for the help on that!
This query displays the dates that the training was done and using an ii...
[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, I'm new here. I'm not sure if this is the right forum for this, so let me know if it isn't. I started a summer job in May, taking over as the database person here. The database is not in good ...
[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 everyone, i am currently working on a database which lets you keep track of inventory and changes in inventory. I have the database set up with Inventory_Items which stores the item name, desc...
[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
How would i go about storing a file name, not the file directory, just the file name using a dialogue box.
Many Thanks
Roosn
...
[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
This is probably an easy to do, but somehow I am stuck.
There is a field in my form that lists if the company is a hospital or clinic (OP or IP).
And then there is a field in my form that show...
[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
Can anyone tell me if there is a way to look up a field on a form. I have a menu bar, which is really a subform with buttons. This menu bar may be on several different forms. Some of the button...
[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
The Lookup filter was placed after the Aggregate filter resulting the lookup values are not used in the Aggregate. This only occurs in the show mode and the other modes (like download) is OK. Prob...
[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
We are using MS sequel server and have a production data base provided by a third party. We need to create additional views, stored procedures and even some customized tables.
My question is:...
[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
Good Morning:
I have a problem autoincrement a field "OrderNumber", I have a Listview with four column: "QTY", "Description", Price:
This is my code to save ...
[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 there
Hope someone can help. Ive recently just finished a database. At the moment the frontend is being used on the server instead of the client pc. I know this should not be the case but it'...
[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
Please help. I am not new to Access, but I haven't done much with some parts of it.
I have a table and ran a query on that table. I have a form that displays data from the query. How can 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 there,
I have a form that I want to be opened and insert one new record into the table. When the form loads, the following happens:
1) Create new record
2) Put a default value into a control 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
Browse sub-categories 
