Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Search results for query: *
- Users: idbands
- Content: Threads
- Order by date
-
How do I make this form using records from a different table?
I have 2 tables - orders and orderitems. I need to make two refund tables that are exactly like orders and orderitems. I did this, no problem. Now I have a refund form that users will use when doing an order refund that should write new records to the refund_orders and refund_orderitems...- idbands
- Thread
- Replies: 4
- Forum: Microsoft: Access Forms
-
How do I set this option without SQL Server? (Arithabort)
We have a 3rd party application that we use that uses SQL Server. I don't know too much about SQL Server; I think we only have the client version installed? I can access the SQL Server tables through Microsoft Access (via the SQL Server ODBC driver) and run lots of queries and updates which I...- idbands
- Thread
- Replies: 5
- Forum: Microsoft: Access Other topics
-
How do I set this option without SQL Server? (Arithabort)
We have a 3rd party application that we use that uses SQL Server. I don't know too much about SQL Server; I think we only have the client version installed? I can access the SQL Server tables through Microsoft Access (via the SQL Server ODBC driver) and run lots of queries and updates which I...- idbands
- Thread
- Replies: 3
- Forum: Microsoft SQL Server: Programming
-
Need customer invoice. Are there report templates?
I actually love Access for many reasons but I HATE HATE HATE the reporting module. I've gotten by so far without needing to write a report in years, but now I need just a basic customer invoice that looks PROFESSIONAL which is nothing I could accomplish in Access. Are there report templates...- idbands
- Thread
- Replies: 2
- Forum: Microsoft: Access Other topics
-
Help with making this query updateable with 3 joins.
I'm really struggling with this. I have this query: SELECT OrderNumber, Code, dbo_OrderItems.Status FROM [Picking], dbo_OrderItems, dbo_Orders WHERE ((clng([Picking].CONumber)=dbo_Orders.OrderNumber) And (([Picking].ItemNo)=dbo_OrderItems.Code) And (([Picking].isShort)=-1) And...- idbands
- Thread
- Replies: 2
- Forum: Microsoft: Access Queries and JET SQL
-
Can I store query rslts to mem so query isn't run over & over again?
I hardly ever write VBA code but through a lot of research I was able to put this together (below). The code is supposed to take Order Item records from an Access query, group them by Order Number, and put the information into a fixed-length file (there is one file for each order). It was...- idbands
- Thread
- Replies: 1
- Forum: Microsoft: Access Modules (VBA Coding)
-
Sub or Function not defined? How to fix?
We have a program that sends e-mails through Outlook and Outlook previously popped up with an error warning that an outside program was trying to send a message. To get around this error, we were told to enter this VBA code: Public Function ammolSendMail(strTo As String, _...- idbands
- Thread
- Replies: 9
- Forum: VBA Visual Basic for Applications (Microsoft)
-
How to update records when there is a multiple join?
I have two tables a, b. Table A has a bunch of data. Table B has nothing in it (the two fields in the table are Order Number and Notes). My query pulls a bunch of data from A and then you can type in a comment in the Notes field that then gets written to table B. My query looks like this...- idbands
- Thread
- Replies: 3
- Forum: Microsoft: Access Queries and JET SQL
