astroshark
Last Activity: Nov 13 '17, 08:13 PM
Joined: Mar 5 '17
Location:
-
You are correct in assuming that I did catch the naming convention and corrected it accordingly. I have attached the backend of the database stripped of sensitive info at your request.... -
I tried fixing it myself, but I am coming up with nothing on it. I have the function set on the AfterInsert Form code. Every time I try to submit the form it gives me Run-Time Error 94 "Invalid use of Null" at Line 25. Is it because my field is not a numeric field?Leave a comment:
-
1. There are some numbers (The Manual Entries) that will have leading zeroes and those leading zeroes are required, and the only way I have found to make it work is to make it a string. The manual entries will have a wide range of entries ranging from 0001 to 9999.
2. Yes
3. YesLeave a comment:
-
There are about 48 fields within this table I have attached a text file of the fields. The data types of the fields are denoted by the name of the fields. I had to do a little bit of reformatting of the text file so I am note for sure if it will show up the same way on your computer....Leave a comment:
-
I apologize for the extremely late response I was away on business. But it looks like it's headed in the right direction. I tried adding a WHERE clause to the statement to ensure that it only counts the current day's records, but when I do the sequence number doesn't increase and stays the same.Leave a comment:
-
Thank you very much this helps solve part of the problem as it does go in sequence. I am trying to tinker with the code because I need the number to seed at 8000 and reset daily. But I am unfortunately getting no where with that. I am assuming that I need to use it as an argument within the function? Because right now since I have no records as of today in the database that functions starts off at the number 10 only and just goes up from there, it...Leave a comment:
-
Yes you are correct the proper sequence would continue off 8006 to go to 8007 and the larger series of numbers would just be manual entries. Which I would like the larger series of numbers to be ignored from the proper sequence. I would like to note that it does NOT matter if the numbers end up duplicating each other.Leave a comment:
-
So in terms of coding are we talking about just looping through?Leave a comment:
-
Right now there are multiple values that the system could ask itself does this entry have a certain value? And yes it does there are several fields within the table that if these entries are entered in manually it will say "MANUAL ENTRY". So is there VBA code that will allow me to flag these entries that say that within the DMax code?
Because I don't care if the number duplicates or not I just need it to go in proper sequence...Leave a comment:
-
Fix Gap in DMax auto incremented numbers
I have this code
This code increments a number starting at 8000 and restarts every day, but I am running into a problem. Our database requires that some of these numbers be entered manually which are completely different numbers usually higher than 8000 leaving a...Code:SerialNbrValue = Val(Nz(DMax("strSerialNumber", "tblOrderData", "dtmDateOrdered=#" & Date & "#"), 7999)) + 1 -
Increment Number
I am relatively new to the C# scene so I am a lot of rough around the edges. Anyways I am trying to pull a number value from an Access DB starting at 8000 and increment that value by one every time a user enters a new row into the Access DB, and then get that number to reset daily back to 8000. Also having that incremented number show up in a textbox once the user has pushed the data into the Access DB. I have a rough draft of some code, but of course,... -
Data Source Queries
Hello, I am relatively new to programming in C# and am trying to get a handle on coding with it. I created a query using the Visual Studio query designer in the dataset that is imported into the project. Now what I can't do is seem to find a way to display that data from the query I created with the designer in a list box. Any help on this matter would be greatly appreciated. -
No clue what I did haha I played with it and then when i'm looking at it, it's back to your original code and it works once again. Thank you for your help!Leave a comment:
-
I think I found out my problem will report back when I test it out.Leave a comment:
-
So thank you for providing this it has worked to some degree, it works but I changed the date on my computer manually to check to see if it would reset the number, the access form detects the date, but when the next day happens the number resets to 1 instead of 8000. I have tried playing around with the code, but have not found any viable solution to it.Leave a comment:
-
Fixed autonumber reset everyday
I have a field in a form that I want to have automatically generated a number. Specifically, it starts at 8000 and goes up by one every time a number is used. Multiple people will also be using this form at the same time.
So let's say Person A and Person B open the form at the same time, so they both get the same unused generated number. The goal of it is if Person A submits his form first, then I want Person B form to lookup records... -
Remove Whitespace from Report with Tabular Layout
I am trying to see if there is a way to remove the tiny white space that is set in place by using the tabular layout. I set all the padding to 0", but it leaves the tiniest whitespace only viewable in Print Preview as well as an actual printed product. Any help would be appreciated! -
Answered my own question I inputted a criteria into the query for each seperate field.
Code:Like IIf(IsNull([forms]![frmCompletedOrdersMenuDateRange]![txtRequestor]),"*",[forms]![frmCompletedOrdersMenuDateRange]![txtRequestor])
Leave a comment:
-
Text Input Filter Criteria for Report
I have a form that generates a report based on a date range input, but I also want to add multiple "OPTIONAL" text fields to where if a user inputs a text into this field it will filter the report data by the filter and date range. And to also display an error if the text inputted does not exist in query. Here is what I have so far. I have a query and one of the fields in that query is named "Date Received" which has the following...
No activity results to display
Leave a comment: