Search results

Good Morning! I have a table that records stock trades - date, ticker, buy/sell, quantity, etc. Does anyone know of a way to run a query that would put this information into Outlook 2010 calendar? Thanks!

Good Morning, I have a query that identifies records based on dates. I currently have it set up to identify all records within the last year. Here is the little code. >Now()-"366" However, I want to put in a formula that will select a year time frame based on the last quarter. For...

Good Morning, I have a database I have been testing with various users - it is just a standard split database. Some users have no issues with it, but there are a couple that can only open it up as read only. Any ideas what may be causing this issue?

I have a question. I want to set up a database (split database) that a user can download and run it. The issue I have is that the linked tables are not up to date, so the user has to manually update the links to go with their computer. Any ways to get around this issue?

I have been recently asked by an Industry Publication to share a database that I have created for my firm. I have requested that they get me a handful of my peers to test out the database and make any suggestions for improvement. Problem is that I made the database on Access 2003 and it seems...

I am looking for a excel formula to accomplish the following. Column A Column B $500 $750 X $100 X Can someone give me a formula that calculates the sum of Column A where there is an x in Column B?

Quick question, I have a spreadsheet with two columns: code value d $100 s $50 d $100 I want a formula that sums the total value column for rows where the code = "d". In this example, it would be...

Greetings, Whenever I compact my database, it creates a compacted copy of the database (leaving the original database uncompacted). How do I correct this? Thanks, WB

Anyone ever get this error? I have it currently when I try to update data in a linked table. Anyway to circumvent this? I believe I have done it before, but can't remember. Access 2003.

I have an issue, I need to format a field from a table. the field is [acct_num], and the current format is this (bad I know): ### - ###### - ### or ### - ##### - ### I need to just have the middle 5 or 6 numbers for the query, drop off everything else. Plus, where the middle numbers...

Access has rotten my brain. Whenever I need to write a formula in Excel, it is a challenge to remember. All I want to do is create an IF THEN statement that recognizes words within a colum. The idea is that when "Pension" appears in a column, it would do something. But "Pension" only...

Greetings - I am running on Access 2003. I have a table that has a field which is an autonumber. The problem is that I have an Auditrail Mod (from Irish) on a form that requires a Record ID (autonumber) to run. However, Access doesn't let me have two autonumbers in the same field. So when I...

Greetings, I have what I hope to be a simple error that is a result of me not being VBA-savy enough. Basically I took Irish's Audit Trail module and tried to customize it a bit. Basically I wanted to add a field in the audit table that captured an account number, so I can easily search for...

I have a form that will be used by multiple user in order to input new account information. Depending on what is selected, the data can be stored in 3 different tables, and once this code is executed the data is "erased" from the form. I also took away the navigation buttons. The reason for...

Good Morning, and a Happy Festivus. I have a form on Access 2003 that a user will use to input data into an account table. Because a number of users will be on this database, I have created user IDs (via Security Wizard) that they log in with. I want to create a sort of audit trail, so...

Good Morning, I have been searching through the forum the last couple of days for an issue I am dealing with. I have a form that will be used to open new accounts. On the form, the user can select which items are missing, then click a button to send an email listing the items that are...

Good Morning, I recently started at a new company that needs to have a good database setup. My task is to lay the foundations now, and build upon over the years. I'm basically starting with a clean slate (and no interferring coworkers with Access knowledge). My question is that we...

Been awhile since I have posted on here - but I am going to need some help. I've recently started with a new firm that has ZERO employees with any Access experience. I've recently introduced some process improvements that can be done via Access, and got those in charge all riled up. So now I...

I have a newb question. I've never set up my own database before, just used what was there, and just finished linking tables into the new database from a SQL Server. Question, is protection needed on these linked tables so that users can mess up the original data from the server, or is this...

Good Afternoon, I have the below Union Query that I want to turn into a make table query. But I can't figure out where to put the INTO clause. No matter where I stick it, I get errors. SELECT acct_num, br_id, fa_id, acct_pgm, acct_pgm_assn_end_dt, client_tr_dt, trade_date, trans, symbol...