Search results

I haven't been able to find a clear answer to this, so I hope someone hear may know. I know that SQL Server Express database has a size limit of 10G but when that size is approached, can you just create another database within the same instance of SQL Server and start anew? So if I have 3...

I see. I figured it would be something along those lines but wasn't sure. On the reports On Open event I would just set the image to that path then correct?

I do already have them but am curious the process I would have to use to get the report to know which to use. I have never messed with images outside of a static company logo that doesnt change.

Is it possible to add QR codes from a stored list when the report is opened? I had made some product labels for my work and thought it would be nice to also include our system generated QR codes for them but cant fathom how I would tell the report which code to use when it was opened. In my...

I had that problem with the first computer I built. Since then I only ever by full size towers and eATX boards so I have ALL the room to work in. When I get to rebuild it, I want to use Thermaltakes The Tower 900 case, which is absolutely MASSIVE.

I feel this. My home PC has bad hardware that I have yet to isolate to figure out what is bad. I have narrowed it down to either bad RAM or bad RAM slots on the board itself. My poor computer blue screens constantly with an ever changing error code (which is why I am having trouble fixing it)...

Doc, I do just want to say I always really enjoy your responses. I am not sure what it is, but I always find your responses very insightful and extremely helpful.

I have wanted to try PowerApps as I want to move more towards web based apps but my IT department has it locked for sign up and hasn't agreed to unlock my account so I can try it :(.

Ah that did it. Added num = Format(num, "000") and that lets it work with the "LIKE" test.

The number string never goes beyond 000 00 but once you get to 999 00, it becomes alphanumeric and would be AAA 00, AAB 00 etc. Wouldn't that cause an error if you tried to convert it to a number?

I have been searching for an hour to figure this out to no avail. I am trying to delete rows if the user entered condition matches a cell value but the value to compare it to has leading zeros and therefore doesn't match. Example: User enters the value "2", loop through the column on another...

I got it working Gas :). Once I releasing I was being an idiot yet again, I fixed it quickly.

It returns the value when it finds one, otherwise it creates another empty entry in the array. Now that I realized I should have had this as a table all along, I am rethinking my approach a little bit on it. I should be able to just find the last used row in the table, then loop through it...

I am trying to "scan" the sheet "Job Info" which uses a sort of template for users to input basic order information and some criteria: This little block is repeated over and over for as many orders as they have. When they run the report, the user is asked if they wish to run it for specific...

Yup I made that change so it is auto added every time It is a frozen python script in a .exe format. I changed how I was running the shell a little bit and think I worked out all the "jank" by adding in more quotation marks to fully and nicely wrap the file path. I also have to use...

I am an idiot and this is why I really should use Option Explicit on every single module as well as better variables names, I had misspelled some of the variables. Once I noticed that and correct it, everything works now. While I am at it though, in regards to the last code segment in post #10...

I am. That section looks through the sheet to find the order number then offsets to grab the rest of the information for the variables. If the IF statement for c is ran, it exits the entire module as there is no information to use. I added in the sheet reference to rows.delete but it...

The variable is getting the values correct but for some reason the criteria for the IF statement is never met and the rows do not get deleted even if column 5 on the given row has that status. I changed it from .value = to .value Like and even added a wild card and it still never seems to enter...

I went through and made all the variables unique across the entire workbook but that block still doesn't delete rows unless I run the module by itself. Maybe its a problem with not explicitly naming the sheet...

I spend a lot of time doing it now a days, so I can actually practice and get better. Also have gotten much better at wording questions for Google searches :ROFLMAO: