I need to insert a calculated field in my query that will for each calendar date record show which fiscal month the date belongs to. The START DATE for each fiscal month is the the first Saturday ...
[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 all,
I've hit a snag. I have a surrogate primary key - a unique ID that is input by the user. Frequently people will enter an ID in order to fill out a different part of my form, and they wi...
[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 looking for an easy way to enforce Title case when typing in a name in a forms text box. I thought I had an example I had used before, but am having no luck.
Thanks in advance
Mike G
...
[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 would like to create a button on my form that will search through my e-mails in Outlook, find the e-mail with a certain subject line, and include that e-mail as an attachment in another...
[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 MS Access 2000 limited to how many computers you can install it on?
Or is it a one install program, if you want it on 5 you have to buy 5 copies?
What if a company that has not bought a new upd...
[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
Oracle unveils a number of enhancements to its enterprise performance management system and detailed its Hyperion integration efforts in a lengthy and wide-ranging Internet press conference.
...
[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 am learning access and VB as i go along so please forgive any obvious questions i may be asking.
I have a personnel table where records are entered in via a form.
Some fields are: Last 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
Hey guys,
Is there a function that would let me know if a field value is purely numeric (no symbols, no letters, no spaces)?
I'm thinking of using in an if/then statement like:
iif([field] isNume...
[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 made a query (and its pivot table view) and would like the numbers to be in certain format. I could format the underlying table but not the query itself.
1. Is there any way to format it?
2. ...
[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
Okay, I have the same subreport within more than one report. If the subreport is being used within the report called "BriefQueryResult", then I don't want a certain textbox in the subre...
[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,
Obviously from the title, I need a little help with a query.
I have 2 tables. One is a favorites that will look up into another.
So in the favorites table I have 3 fields. UserName...
[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 3rd party OCR software that can only export a date in a YYYY0DOY format. The 0 just separates the 4 digit year (YYYY) from the number of days into the year (DOY). So, for example it put...
[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 SSIS package that pulls data by SQL query and creates an Excel spreadsheet. However I'm having trouble formatting the date range it pulls by. It's going to run every monday and I need 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
i am uploading a small text file to web server using inet1 and ftp. it works but - i've read that this is a security risk. am not concerned about the file that is being uploaded, but do care that ...
[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 on which I construct a string containing a dynamic query, the string containing the query is then passed to a report, the report recordsource is then set to the query stri...
[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
ok tricky and odd.
The project I am taking over well, the previous guys did a horrific job.
Basically, we have records of tracks and each track is suitable for a particular occasion.
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 currently have 2 excel spreadsheets, one is relatively stable data referring to manufacturers of parts, order numbers etc, the other is more dynamic as it records data of individual shipments 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
I know this has probably been asked before but I thought I'd ask again; If someone copies a .mdb with the tables in it how can they be stopped from attaching to it and pulling out the data. I know...
[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 Experts!
I have two combo boxes on my form, where in one it should be the company's name and in another one it should show the names of all the contact person's name in that company, like compa...
[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'm not sure what's happened with my Access DB over the past month, but it has over quadrupled in size! I went from an average DB size of 55Mb to a whopping 246MB! I used to run a compact/repair...
[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
Im currently looking at converting an Access database to MySQL and I have been reading bits and pieces on the internet about how to do it but im a little confused to the best route to take.
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
Hi there.
I'm new to the forum and the programming with VB.
I have set up the forms and have linked them by using buttons.
I have 2 databases for Individuals and one for company informations...
[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 it possible to colourcode rows in a subform datasheet based upon them being higher / lower than the previous row ? ...
Subform datasheet has, e.g.
Row1 £12.50
Row2 £10.25
Row3...
[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,
Im running some code in access to select fields from a table, but im wanting to have a sum within the select criteria as each member has several records and i only want the sum of all 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 all,
Im running some code in access to select fields from a table, but im wanting to have a sum within the select criteria as each member has several records and i only want the sum of all 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
Browse sub-categories 
