Search results

Ah ok let me adjust and try again. Thank you for your patience. All I ever did in the past was make a new query with an SQL statement limiting the data.

Still no luck. I am trying the following combination to try to filter this, but I think I am putting something wrong. DoCmd.OpenReport "rpt_DailyCoversheet", acViewPreview, , "txtDate=" & Me.D_Date Ok, so the txtDate is the name of the field on the report. The Me.D_Date is the control source...

I am trying to filter the records based on the last date entered. So for instance if the last record to be entered was 12/03/2024 then I want the data for that date on the report to appear. But let me give this a shot. I am still trying.

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...

Thank you for the link. I am working on another part right now, I was just trying to get the information available to me before I got stuck there. Once I am at that point I will delve more into it. I will mark this as solved for now, it looks like what I am wanting. Again thank you.

Ok, I will try to explain it a bit better. You know on excel you can format the boxes to fit into one page and be displayed as squares all across the page if there is data or not? Something like that but done on access without the use of excel so I can try to get this report inline with all...

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...

I have tried it. And what happens is the security warning pops up and says that type of file is not allowed. I work on a military base.

Oh I like that idea. When I have a chance I will look over the link u provided. Ty for that idea.

This db ionly used on one computer. There is multiple users, but only one can be logged in at a time. The current db we are using I made like 4 years ago. I have had no issues with it, it does have code.

Due to security restrictions in place where I work, splitting is not an option.

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?

Thank you, that helps and clarifies the things I needed.

Well for the first part I am referring to the 255 field limit placed on tables and queries.

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...

Okay, thank you all for the clarification. I was just curious.

Well, I have tried to link the data to an excel spreadsheet and I accomplished that. What I am running into problems with is the data can't be updated through access and only updated in excel. Did I do something wrong?

So when you link the table, is the data still stored on the table at all?

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?

Well, the data being reported up is all about date specific. There is essentially nothing else tying the data together. I might just be in a unique situation where the date has to be the primary focus. The form BeforeUpdate event does not work correctly for me as far as I can tell. However...