Morning everyone!
I have a little problem Im sure you can help me with.
At the moment I get a spreadsheet from the bank every month which i import into our database. At the moment I do this...
[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,
In my table one field has several codes to relect the fact that on equity can be listed on multiple indecies. It looks like this
;2;5;1;1;GF;1;LX;1;GD;1;SE;1;GB;
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
Hi All,
I'm hoping someone can help correct the holes in my knowledge.
I always belived that running a backup of your database cleared the transaction log. The physical size of the transact...
[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 developed project in VB and used SQL server 2000 as database.
when I run exe it will definately require a database, but it is inefficiant
to install SQL server wherever I execute my project...
[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 listbox with more than one record, 2 textbox
i want to insert the data from all 3 objects in the sql table but with the below code i am not able to insert it.
eg suppose i have 2 na...
[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
Howdy accessians -
I have 2 text boxes on my main navigation page - first box selects a country - and the second box selects a report from that country.
The second box has a query that is dependa...
[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 (appreciate if someone can provide some suggestion),
SITUATION:
1. I have main form that contain subform.
2. Subform generates display of an APPEND QUERY.
PROBLEM:
3. Though in my query 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
Guys can you tell me how to
transfer textbox values to the list box. automatically
bec i want to continually add the information.
to the list automatically.
meaning all the dates that i input to ...
[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 getting down to the wire on my little beastly application and I need some help again. I've just redone all the forms to run maximized with boxes that adjust around each form upon re...
[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. Is there a way to set the default view in Access 03 and 07, so when a user opens the file, the correct view is already open?
For example, I have a simple contacts db. Inside are two views: a 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 need help with my database. I have problem, when I input the ip address on the textbox and when I click the button, I get access to the ip country database to read the information of end num ...
[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 no expert when it comes to VBA or SQL codes, therefore, the solution of my request may be lengthy, but it needs to be simplistic. What I am trying to do is to list out the top 2 list of my s...
[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
Just a question out of extreme frustration in trying to deal with MS's toy database.
Apparently, if using a table to update another table and the source table does not have a primary key then 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,
how do i filter the dates in the table using a query that will only display dates corresonding to the current year...
Assuming that the table has dates from 2000-2008..When I run...
[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 everyone. Again.
I'm using Microsoft Access 2003, an OleDb connection and Visual C# 2005.
I'm using a mostly databound datagridview, with a single unbound column called "status&quo...
[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 been linking dfb files to MS Access 2003 for some time, always reading successfully (my VB app runs queries using these linked files). My client updated to Access 2007 a couple ...
[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
Suppose I have a table, that has 2x columns: FIRST_NAME and LAST_NAME
some of the data in these fields are all in UPPER case while in others are all in Lower Case.
Because, these are first and las...
[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
Access 07 has new response to exit command in macro...
The command or action 'Quit' isn't available now.
*You may be in a read-only database or an unconverted database from asn earlier version of...
[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
Guys - big thank to everyone who has help in the past , hopefully in the next couple of weeks I will start my next project, which is a rebuild of what i have been working for the past 12 months - ...
[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!
Ive created/refined this code to read in data from several tables into my access but i have a problem with SUM. With this code im trying to add together all the null values that have 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
I have been looking through the search results using various phrases to try to find what I need. I probably have found it but just don't know how to apply it. I have a Date_Created field to pull 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 been trying to create a report that would count the # of new sales orders weekly.
The problem is that multiple sales order records are created due to system limitations
(when actually ther...
[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 Access/Excel 2003
This may become an ongoing discussion. I'm not sure, but I might have asked this before. If I have, my apologies, but I am now at the stage where I need to begin...
[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:
Previouis developer didn't put comments on below Sum function, so I want to understand this totally before I do any modification, here is the code:
Sum(IIf(DateDiff("d",[Date En...
[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
Sometimes when I create a quick query just to check something, then try to close the query, I am prompted for the name to save the query to instead of being asked if I want to save the changes to ...
[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 
