Access Developer Forum

This is a Forum for students in my Access Developer courses. Yes, you can still post questions in the comments section of the individual courses, but I will be using this Forum to post general notifications, ideas for future lessons, etc.

I recommend you subscribe to this Forum if you're interested in getting these kinds of updates. I'm not going to send out individual emails for everything.

Click Here to Post a comment and start a new discussion

Export Query to Excel Template Upload Images Link
David Czerwinski
18 hours ago

I want to program a button to export a query to excel and it works fine but overwrites the SS. I want to export to a template excel that has all my conditional formatting. this code works but overwrites Read More...

Alex Hedley
17 hours ago

https://599cd.com/blog/display-article.asp?ID=352&CommentID=43732#StartOfComments

David Czerwinski
15 hours ago

Alex your reply just takes me to my original post in the general questions? I posted there but got no replies so I thought Id report it here. Was that the wrong thing to do?

Show 2 More Replies...

RichTextPlainTextSQL Server Upload Images Link
Joe Hood
2 days ago

I have a Table on my SQL Server that has a Rich Text field. I am using a pass-through query to display the field in a list box on a form. Is there a function that will convert the Rich Text to Plain Text that I can use in the Pass-Through Query?

Richard Rost
21 hours ago

Does the PlainText() function work? Not sure if it does in a PT Query.

Joe Hood
21 hours ago

It does not work in a PT Query. That is the first thing I tried. I have found several options on google that seem to use a functions that has to be added to SQL Server. I have not been able to make any of these options work yet. I guess its a little above my skill level. For now i simply eliminated the field from the list box and added a Rich text box that Dlookups the text I want on the List box onclick event. It actually works pretty well and leaves the list box much less crowded and nicer looking.

Show 5 More Replies...

Form Question Upload Images Link
Amina Jones
2 days ago

I have a database where I have two types of clients. Employee and Customers. I have two separate tables for each. I also have a pymt table to track payments for each client. The pymt table identifies the type of customer (employee or regular customer) I have two forms, one for employee & one for customer, and each form has a pymt button. I also created a pymt form for the pymt button to view and add pymts. Read More...

Amina Jones
2 days ago

Show 10 More Replies...

Amina Jones
2 days ago

I only want the customerid to show when i view the customer pymt history and only want the employeeid to show when i am viewing the employee pymt history

Dg Ewing
24 hours ago

If I am an employee and purchase something, am I assigned a customer ID, and if so how are trying to populate the employee id field on the payment history form?

Amina Jones
23 hours ago

The employee table has an employeeID -PK and Customer table has CustomerID - PK. The third table is the pymt table and they both use the same table. Both PKs are foreign keys in the pymts table. I have a pymt form and the pymt form is used on the employee form and the customer form.

Richard Rost
22 hours ago

I would put customers and employees together in the same table and just differentiate between them with a field (IsEmployee for example). Would make everything else so much easier.

Amina Jones
21 hours ago

I did two separate tables because the customers membership to the gym subscription is through referral link from the employee. So i did two separate tables.

Amina Jones
21 hours ago

Dg Ewing
2 hours ago

Amina, I may not yet understand your problem, my questions are seeking to understand, not to question your logic/architecture>

Your payments table does not have both customer AND employee IDs populated for any paymentID records....if your pymttransactF is reading the payments table there is no data to read....???

Dg Ewing
2 hours ago

Is your question how to populate the payments table with the employee ID when the transaction is an employee? and if so I would use vba on after update of the customer ID in the pymttransactF and set the employee id equal to the employee id to what appears to be subform {right hand side} on the Customer Information Form above {employee 1}

Kevin Robertson
2 hours ago

Can't you simply hide both ID fields?

Show Older Comments...
View in Table Format