Search results

I've got a spreadsheet that I put together for the company's metrics. As it sits it works great. I'm pulling in a query from an Access DB for some of the data. I realized yesterday that I cannot open/run the query from another computer. The query is looking to...

I'm working on pulling a bunch of data together for a form but need to be able to edit the data. I realize my query is using some joins that make the query itself read only but I've been going back and forth trying to come up with another idea on how to write everything so that it would be...

I can't seem to get my IF statement in a macro to work. It keeps coming up with an error "Cannot Fine Name tblImportLogDate you entered in expression" Is there any reason this would not work? [tblImportLogDate].[TodayRun]=Date() or [table]![tblImportLogDate].[TodayRun]=Date() (this gives the...

I've set up a scheduled task to run an EXE every morning at 9am but it does not seem to want to work. I set up the task using the computer's ADMIN account - not my personal log in because I want this to run every day, regardless of if I am at work or not. Under Security Options for the task...

I'm working with some databases that were not fully thought out and I need to join some fields where the data might not be the same. I could use another query or two and make it work - but I'm trying to avoid doing that if at all possible. How would I join the two tables if my customer table...

I've got a huge list of information I need to sum into months and then chart. Here's a sample of the data: It goes on for 5+ years ReportDate Count Identified Count Sent Count Responded Count Flapper Count NTF Count Cleared 09-Oct-17 9 2 06-Oct-17 6 2 05-Oct-17 7 2 2 04-Oct-17 9 4 1...

I'm getting to the point I really dislike Office2016 products. Things that used to work for me or be easy to do have become nightmares.... I built a query in Access that I want to graph. I have always hated Access graphing (probably just inexperience) so I use Excel. I opened a new Excel...

According to Microsoft (probably my first error in trusting them) DeleteObject is still available in Access2016. I'm not sure why, but I'm not seeing it or I can't even type it in. Honestly I ran into the same problem when I was using the ImportExport Text command in the macro. Only reason I...

Probably something simple here but I can't seem to get it figured out. I've imported a huge text file and have pulled out the relivant data I need to store using a query. The data comes out like: (date) ... 9/29/2017 (B)...1 (T)...0 (F)...18 (I)...101 (Z)...82 But I need to put this into a...

I've been looking without success for an answer to what is probably a stupid error I am getting. Recently upgraded to Office365 and methods I used with Access 2000 are not working here. My form has a combo box for a user to select an account number. I want to use that selected account in a...

So we have just updated office suite at work to Office 365. I was asked to put together a quick dbase that would pull in information from a few different places to give our telephone support people some historical data. That was easy enough to do, but when I went to create a new dbase I saw...

My DB has been running great for years. Then recently I've started having an issue with it I cannot seem to solve. Hoping someone here may know what's going on because I cannot find it. I open up a form that views inventory items and click a button to add a new record. Viewing the items...

So I've worked myself into a small bind that I've not been able to figure a way out of. I {had} a form working just how I want, allowing the end user to see a set of records and make changes as needed (basically all they do is update a flag). However, I wanted to highlight certain records that...

I run a daily trouble report but I am not getting weekend troubles looked at because the report only looks at today's issues - Query uses =DATE() as a criteria. I want to run a 3 day report if today is Monday. I have read through several threads here, and other places, but have gotten nothing...

Not sure if this is possible - or what may be needed to even determine if it is. I've got a form that lists anywhere between 5 and 20 accounts that require some type of action on today. On this form, I have a button that opens a subform to show any historical notes for this account. This...

Okay, so I have an existing DB that was thrown together in a rush and done incorrectly. I am trying to recreate it from scratch, but I want to set this up correctly. So far I thought I was on the right track, but it is not operating as I would expect - or I am overlooking something that I hope...

I've done countless imports into DBs in the past and never had issues before today. Not sure what is happening here. Below is a sample of the data I am trying to import. Its exported from another program that I have zero control over and cannot change any formatting. I've tried to pre-set up...

This one has stumped me for a while. Was wondering if anyone else has seen this issue and may know why it is happening. I've got several queries where users can input a criteria ... I.E. using [Enter Part Number] or [Enter Vendor] as my criteria. This has always worked and is still working...

I'm trying to clean up a database as well as have to modify it a bit. For the record; this DB was created YEARS ago by another guy no longer with the company. This DB has a TON of queries that I cannot tell if they are being used or not any longer. Is there any way to determine what - if...

I'm not sure if this is possible or not. But if there is anyone that knows he/she would be found here! Is it possible to show an alert/reminder any time data in a particular field is entered or changed? It would have to show up if the data was changed in table view or query view. Until I can...