Go Back   Access World Forums > Search Forums

 
Showing results 1 to 19 of 19
Search took 0.00 seconds.
Search: Posts Made By: theseus
Forum: Queries 11-09-2018, 05:26 AM
Replies: 10
Views: 186
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: 186
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: 9,575
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: 606
Posted By theseus
Forum: Other Software 09-24-2018, 05:31 AM
Replies: 22
Views: 606
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: 331
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: 331
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,548
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: 180
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: 381
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: 216
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: 216
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: 216
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: 207
Posted By theseus
Re: appended data not visible in queries

Nope no error messages at all. That's part of my frustration.
Forum: Queries 08-06-2018, 08:38 AM
Replies: 12
Views: 207
Posted By theseus
Re: appended data not visible in queries

Thanks for the advice. When I rebuild the db I will implement it...


As for the import code. I have been importing the new data into a separate table then running an append query like below for...
Forum: Queries 08-06-2018, 07:55 AM
Replies: 12
Views: 207
Posted By theseus
Re: appended data not visible in queries

The new data is formatted just like the original data, but contains new assignments that were made after the db was created. It should not have new departments but may have new student groups,...
Forum: Queries 08-06-2018, 07:38 AM
Replies: 12
Views: 207
Posted By theseus
Re: appended data not visible in queries

I don't think that table 2 is being updated and I am not sure how to go about that when I append the data.


When I go to the individual tables, I can see the data there. However when I run a...
Forum: Queries 08-06-2018, 07:18 AM
Replies: 12
Views: 207
Posted By theseus
Re: appended data not visible in queries

Here is an zipped file with the structure and a sample of the data as I get it. I have to strip out a lot of data because of security.... Table names and relationships are all the same.
Forum: Queries 08-06-2018, 06:05 AM
Replies: 12
Views: 207
Posted By theseus
appended data not visible in queries

I have a huge database that tracks my company's employee training. As of mid-July it was 154k records. The data comes to us as a .csv file. After importing and normalizing the data, I end up with 7...
Showing results 1 to 19 of 19

 
Forum Jump



All times are GMT -8. The time now is 06:49 PM.


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

Sponsored Links

How to advertise

Media Kit


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