Go Back   Access World Forums > Search Forums

 
Showing results 1 to 25 of 30
Search took 0.01 seconds.
Search: Posts Made By: theseus
Forum: Queries 05-30-2019, 10:18 AM
Replies: 5
Views: 200
Posted By theseus
Re: Assigning a value in a query if a null is returned

Stupid me... Don't put it in the Criteria section. I can see this is going to be one of those days...
Forum: Queries 05-30-2019, 10:14 AM
Replies: 5
Views: 200
Posted By theseus
Assigning a value in a query if a null is returned

I am having trouble with my database. I have a query that has all of the values assigned to certain items in the database. However some items do not have a value assigned to them.



Currently...
Forum: Windows 04-24-2019, 06:44 AM
Replies: 6
Views: 4,829
Posted By theseus
Re: How to remove "Activate Windows" WaterMark?

Windows 10 is designed to notice when you make major changes in hardware. Minor changes, like a new graphics card, it is supposed to ignore. It is to prevent piracy they say. You will have to contact...
Forum: Gadgets 04-08-2019, 07:34 AM
Replies: 5
Views: 4,788
Posted By theseus
Re: WiFi repeater

There are lots of different devices like this on the market. Some are better than others. I personally prefer powerline adapters and older routers to fill in the dead spots but I seem to fry them out...
Forum: Politics & Current Events 03-15-2019, 09:29 AM
Replies: 2
Views: 222
Posted By theseus
Re: University Bribery Scandal

I have worked at every level of education, middle school (jr-high, if you are older) to college. Admins rarely know what the underlings are doing. College admins are mainly figure heads for...
Forum: Queries 03-11-2019, 06:35 AM
Replies: 6
Views: 242
Posted By theseus
Re: Query with partial information

Good to know. I'll give it at try...
Forum: Queries 03-11-2019, 06:01 AM
Replies: 6
Views: 242
Posted By theseus
Re: Query with partial information

I have used this in most of my forms as a way to get results. However I did find that it is rather broad in what it lets through.

For example, I have a form that has job descriptions. If I search...
Forum: Access Web 02-05-2019, 01:07 PM
Replies: 18
Views: 742
Posted By theseus
Re: ODBC vs. Sharepoint - which is faster?

Just as a point of record, Microsoft says that Office 365 doesn't support publishing a database to Sharepoint. My manager had me look into this for a database we developed but because of the...
Forum: Forms 01-24-2019, 12:59 PM
Replies: 2
Views: 32
Posted By theseus
Re: Yes/No combo box returns True/False

Brilliant! Thanks. My brain is fried today.
Forum: Forms 01-24-2019, 12:53 PM
Replies: 2
Views: 32
Posted By theseus
Yes/No combo box returns True/False

I have a combo box that is bound to a Yes/No field in the table it is referencing. Everything works as it should, however the combo box displays True/False instead of Yes/No. How do I make the combo...
Forum: Introduce Yourself 12-31-2018, 06:10 AM
Replies: 4
Views: 249
Posted By theseus
Re: Thanks for being here!

I second davidcie comments. The group here is knowledgeable and very helpful. Usually, I can find what I need to know with a good search of the site.
Forum: Queries 11-09-2018, 05:26 AM
Replies: 10
Views: 273
Posted By theseus
Re: Urgent help in query

I still think Gasman and I are correct. Criteria needs to be set to only match the combo box selection. It is a very easy process.
Forum: Queries 11-08-2018, 09:23 AM
Replies: 10
Views: 273
Posted By theseus
Re: Urgent help in query

You need to set the criteria for the query to only pull the data that matches the combo box field. Something likeLike [Forms]![CompanyForm]![c-code]
Have you set the query to only pull unique...
Forum: Web Design and Development 10-31-2018, 09:41 AM
Replies: 11
Views: 12,007
Posted By theseus
Re: Website designing tips-

And yet too many designers ignore those pieces of advice and create junk...
Forum: Other Software 09-24-2018, 07:40 AM
Replies: 22
Views: 1,108
Posted By theseus
Forum: Other Software 09-24-2018, 05:31 AM
Replies: 22
Views: 1,108
Posted By theseus
Re: Viewing RAW files in Access - codec ?

How many slides are you converting to put in your database? I have a 70D and don't use RAW often, because the size of the file is so large (24-25 MB). My concern is that with storing a RAW image and...
Forum: Other Software 09-18-2018, 05:44 AM
Replies: 15
Views: 817
Posted By theseus
Re: Outlook is being a booger

Definitely try this.....



If it works, perhaps uninstall and reinstall outlook...
Forum: Other Software 09-18-2018, 04:43 AM
Replies: 15
Views: 817
Posted By theseus
Re: Outlook is being a booger

Start with Minty's suggestion of deleting the profiles. Are you keeping the mail in a pst or are you leaving it on the server and using imap?


If you are using imap, make sure you have the...
Forum: Word 09-07-2018, 05:19 AM
Replies: 4
Views: 1,869
Posted By theseus
Re: Different size view Word 2026

Check Zoom under View. It sounds like one of you is set to Page Width and the other to 100%
Forum: Queries 09-06-2018, 06:12 AM
Replies: 6
Views: 208
Posted By theseus
Re: Minus Date

You could use DateSerial. Something like


=DateSerial(Year([StartDate]),Month([StartDate]),Day([StartDate])-12)
Forum: SQL Server 08-23-2018, 09:39 AM
Replies: 6
Views: 652
Posted By theseus
Re: updating 1st 5 digit of a column value

Assuming by the area this was posted in, you are using SQL Server. SQL Server has a Mask function that can be used to dynamically mask results as they are pulled. You would need to do a custom mask....
Forum: Reports 08-15-2018, 10:06 AM
Replies: 5
Views: 289
Posted By theseus
Re: dlookup in report - bad behavior

Ultimately this is what I did. I created a new query with the crosstab and the other table with the institution name in it, with a left join between them.


As for the issues with the crosstab...
Forum: Reports 08-15-2018, 07:51 AM
Replies: 5
Views: 289
Posted By theseus
Re: dlookup in report - bad behavior

Since the report is based on a crosstab query, that is why I opted to cheat and put the label using dlookup.
Forum: Reports 08-15-2018, 07:47 AM
Replies: 5
Views: 289
Posted By theseus
dlookup in report - bad behavior

I am using dlookup in a report to pull the name of a facility using the cost center that was entered in a form. This is creating some weird consequences.

When the report is displayed in report...
Forum: Queries 08-06-2018, 08:49 AM
Replies: 12
Views: 238
Posted By theseus
Re: appended data not visible in queries

Nope no error messages at all. That's part of my frustration.
Showing results 1 to 25 of 30

 
Forum Jump



All times are GMT -8. The time now is 02:28 PM.


Microsoft Access Help
General
Tables
Queries
Forms
Reports
Macros
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Featured Forum post


Sponsored Links


Powered by vBulletin®
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World