Hi NeoPa, thanks for all your help, including all the previous posts you helped me with over the years. Don't get me wrong, I love Access and it will always have a special place in my heart. I want to advance my skills in developing and I feel like I hit a ceiling in Access. I like the challenge of learning new daunting skillets, which is why I took a liking to Access in the first place.
Cactusdata, I met with a software developer buddy of...
GKJR
Last Activity: Dec 7 '23, 03:18 AM
Joined: Jan 16 '14
Location: US
-
Take a Database to the Next Level
Does anyone have a recommendation to build a standalone application to replace an Access database? I have my bookkeeping software I developed in Access that I would like to make available to other small businesses, but I want it to be independent from Access. From my own research it seems like I need to learn many different languages such as SQL Server, C++, C#, html, and maybe also master .net framework. It seems like a daunting task but I wouldn't... -
I use my programming textbooks all the time. They follow a well thought out approach to teaching the subject from start to finish. That doesn't mean they're all good, but plenty of them are.Leave a comment:
-
It sounds like you need some professional experience working with an established company if you want to stay in the field. College is great to get your foot in the door for any industry, but everyone is a freshman in the real world after you graduate. If you like it and want to spend the rest of your career doing it, then don't give up after just a few months. If you don't like then find something you do like.
For comparison, I went to college...Leave a comment:
-
I find it hard to believe that Microsoft would drop service for Access. From what I understand Access is widely used as a front-end for many different higher level database infrastructures . It is a very intuitive front-end rapid development tool. One of the things I'm wondering is what other front-end development tools are out there?
My take on Access's niche in the market is for small businesses that don't have an IT department and never...Leave a comment:
-
Professional Access Developers
This isn't a question but more of a discussion point for all of the serious Access Developers out there. I'm curious to hear what everyone thinks about the direction of the market for Access in general. I learned the program as well as VBA in order to develop applications for my own small businesses that I've either worked for or owned. On one hand I feel like that is the intention of Access. Seeing as how it is a part of Microsoft Office and it... -
Finished Application
Hey everyone, I know it's been a little while since this thread was posted. I want to stress how much I really appreciate all the input and how grateful I am to have a community of pros and power users willing to help out with an issue like this.
My needs on this project changed and I actually used a work around where I no longer needed to grab that information at the time the code was creating the records....Leave a comment:
-
Hi Rabbit, my parent and child form are set up properly. The reason I need to use a button to create these Order Component records is because they are actually snapshots of the current costs associated with the raw materials used. A product is chosen in the order, and then my procedure steps through all of the processes associated with it and pulls out the raw material costs to create a permanent record of them at the time the order was taken....Leave a comment:
-
Thanks twinnyfo I will consider what you're recommending and get back to you.
Just to be clear though, my intention is not to open multiple instances of the same form, but rather open the form, wait for the user to make their selection, and then when the form closes the loop continues and opens the form again with the next record. The code on the button in the pop up form simply closes the form.Leave a comment:
-
My order entry form does exactly that, but I want the subform to get opened during the routine as those records are being created so that the rest of the order can be processed in the same routine. These order component records are automatically generated based on the first 3 fields on the order entry form. That is what the first button on the bottom of the form does. I want the rest of the order processing to all be in the same routine, so I don't...Leave a comment:
-
I want an easy way for the user to enter the Operation Line instead of entering it in the sub-form on the Order Entry form. The [Total Cost / 1,000 ft] and the [Costing String] fields are calculated based on the Operation Line. I need to process this entire order at the push of 1 button, instead of splitting it up into multiple buttons.Leave a comment:
-
Here are some screen shots of the items you requested. Also here is some of the code I'm working on...
...Code:Private Sub btnChooseOperationLines_Click() Dim db As Database Set db = CurrentDb Dim rstOrderComponents As Recordset Dim OrderComponentsSQL As String OrderComponentsSQL = _ "SELECT * " & _ "FROM tblOrdersComponentsLeave a comment:
-
Pausing Code to Wait for a Form to Close
I've been trying to figure this one out for a while now and have finally relented to posting in here. I am developing an application for a manufacturing company and I'm working on an order processing routine. Their orders specify a product which is based on multiple processes. For each of those processes, I need to have user input on certain field values in order to process the order. I have developed a routine that creates the child records called... -
The form needs to be bound to the table that you want the data saved in. In design view, under form properties and in the data tab, select the record source to be the table you want to update. You can also update records from a query if your relationships are properly set up. You then need to set the control source of each control to match the field they will be linked to.Leave a comment:
-
That's strange, all I had to do was uncheck that box. I tried doing that before I posted that question and it just came back automatically. When I unchecked it the first time it was in the middle of the list, then when it came back on its own it was at the end. This time it hasn't come back yet so I'll keep my fingers crossed. Thanks Seth.Leave a comment:
-
Missing Reference Libraries for VBA
My database seems to be acting up on me today. It is throwing up errors and highlighting very basic built in functions like Format() and Left(). It's happening when I run my code that I've used for years to filter a continuous form, as well as when I try to use my custom ribbon buttons. I feel like there is a library missing. I've been running Access 2016 on Windows 10 for several months now, and I haven't had this issue before. These are the references... -
Identifying Front End Filename Accessing the Back End
Hi All,
I'm trying to fine tune my audit trail to be a little more accurate as to who is using the database. I'm running Access 2013 on Windows 10 with split front- and back-ends and about 8 total users. I am currently using the Environ("COMPUT ERNAME") function to populate my [ChangedBy] field in my data macro audit trail. Sometimes people may be logged into someone else's computer at my office so I want to be able identify which... -
It is not advisable to create a field in your table that stores the balance. I have made several accounting applications and I simply store each transaction as an amount along with other pertinent details (date, paid to, description, etc.). My report that portrays my data has a sum text box in either the header or footer to show the balance after all of the transactions are taken into account, including the beginning balance which should be entered...Leave a comment:
-
Check the Property on the Format tab "Allow Form View". You may have accidentally set it to No.Leave a comment:
-
Is it really necessary to have the form refresh after the control values get updated? You could put a button in the header or footer that would refresh it when pushed. This way if someone is updating one of the records based on the other records displayed, they could refresh it to be sure nothing has changed since they opened it and then make their change. Access does record level locking so if one person is updating a record, no one else can change...Leave a comment:
No activity results to display
Leave a comment: