Search results

I have my reports setup so I can view all the data for a single month in a report all the way up until the last day of the month. However , I still need to be able to view that data on the 1st of every month, but only the data from the previous month. I have no idea how to make that happen...

Ok, I have half of my problem solved, I just have no idea how to incorporate the 2nd half. So using a simpletext box, and button I can use the filedialog to select a file which I have done, How do I take that file location that is now appearing in the text box and move that file to a specific...

Okay, now that I have my aesthetic boxes problem essentially solved with lots of help from the forums and with thanks to ArnelGP stepping in to help. I have a new question. How do you sum in a report? This report will need to sum the total for each month. I have 2 controls on my report...

Hi, I have a form that has 2 fields. On the first field which is the date, I have my form setup that if there is no value all the other fields are disabled. Once a date is entered all the fields become enabled. Then on that same form I have a 2nd field and depending on the number entered...

Is it possible on a report to have a label stack vertically but each letter is horizontal (see attached picture)?

Okay, I know my question is probably a bit vague and weird. So please allow me to elaborate on it... So what I am trying to find out is this. I have a form, I want it to be able to scroll through all the records to the query it is bound to. I also have a report bound to the same query, but I...

Hi, I know this is probably not advisable, but I was wondering if it is possible to make blank boxes on a report, and as each entry gets filled in it takes up one line of the report. So I have a report that is due monthly, it has 17 entries in columns, and 31 days labelled on the left side. I...

Hi, I have a form with a sub-form on it. I was wondering if there was a way to prevent users from constantly adjusting the sizes of the labels and fields within that sub-form?

Hi, I have 2 questions and instead of taking up 2 forum slots I thought maybe a general question post might be best, but I wasn't sure. So my first question is this. Lets say I have a table with 10 fields in it. Then when I make a query and I want all entries to be in the query, so I drag the...

I just have two questions I was curious about. Can you have all your data linked to an excel spreadsheet, stored there and eliminate the need for a table? If this is possible how can I do this?

Hi, I have been reading up on what I can, but Dlookup confuses me, but then again what doesn't. I have a table called tbl_Coversheet and on that table I have a field called D_Date with the indexed set to Yes (No Duplicates), then on the form there is a field called txtdate for thie field on the...

Ok I have a form where I need to run a loop. The problem is I can get the first set of textboxes to enable on the loop, I just do not know how to get the 2nd set of boxes to be enabled. So here is the code I am trying to play around with but I am not sure if it has to be a 2nd if loop or if it...

Hi, I have been scouring the internet and I can't find a solution to my issue. I have 10 text boxes on a form. The main one (TB1) will be a number between 1 to 9 and also null. What I am trying to do is have the other 9 boxes disabled if TB1 is null, and if there is lets say a 5 in TB1 then...

Hi again, I have a question which some might find weird. How can I open a form and have nothing on it with the focus? A little background on why, I have a form that when I open I want the subform to not be visible (done). I have several buttons on it that when one is selected it stays...

Hi, sorry I wasn't exactly sure what subject line to put. Essentially what I am curious about is if it is possible to create buttons or a menu on the left side of a form and when it is clicked it will open a sub-menu. BUT the main menu does not hide. I am sorry but I do not have a design or...

Hi again, I have an unbound sub-form. On that sub-form when I click a button it loads a specific form. When that form loads into the sub-form I want it to go to a new record, but the problem is the code I use wants the actual form to be opened, so I am not sure how to write the code for the...

I came across a DB with a single form. It is asking the question why are the min, max, and X buttons disabled. There is no code, and I can't seem to find the setting that does this. Does anyone know how to do this? Please enlighten me how this is done.

I have a form with several navigation buttons vertically on the left side. I have an unbound sub-form to the right of that, and when I click on a button it will load the corresponding form into the unbound sub-form. What I want to have done is have that unbound sub-form adjust its width and...

Okay, since my other issue with using tabs was essentially unsolvable due to lack of information available, well at least a lack of information I could find using a search engine. I have a new idea but I am not sure how to accomplish it, not to mention I was researching my other issue and I saw...

OK, I am not familiar with using navigation forms at all. I am trying to learn how to use them. I have created a navigation form. I have opted for vertical left and horizontal top. So here is my question or dilemma. On the left side I want to click the top button if you will. and it display...