Search results

Hi Guys, I'm at the next stage of my database design but I've hit a stumper. I have 3 subforms that I want to show on a form. These would be different lists around 1 account. For instance there would be "pending authorisation by account", "due to expire by account"and "all by account" I...

Thanks Minty

Hi, I am trying to write a query that looks up the current user and returns all records where that person is the salesman. My attempt is below, where i assumed that it would be easy enough to use a Dlookup in the criteria. Can you nudge me in the right direction? SELECT...

Thanks Minty

Hi Guys, I have a form, which I have called Frm_ShikomiregisterINT. I have a command whereby when the user clicks on the button it adds a new record (to the table Tbl_ShikomiRegister) and fills out the salesmans name with their name, looked up from using the fOSUserName module. Dim UR1 As...

Fixed it! used ddif = DateDiff("m", Date, d1)

to explain it a bit. If you take the date as Sept-17 it works as follows: m1 - gets the record from the table m2 - gets the month, so in the example above 9 The if function makes anything under 10 a double digit month - 09 ye1 - takes the last two digits and makes it a year - 2017 d1 - adds...

Hi Guys, I need to find the difference in months between two values. One value would be Now() the second a date from a record. The only problem is that I would need to re-constitute the date from the record. The date on the record is being entered as "Sept-17" for example. Using the idea...

Thanks arnelgp, That worked great!

Hi, I'm getting a runtime 3057 error on the below Dlookup code. Month = DLookup("Month 12", "Tbl_Forecast", "[Subba2]=" & "'" & [Subba] & "'") Both Month 12 , Subba2 and Subba are text fields. I'm trying to use the code to find the date that is saved for Month 12 on Tbl_Forecast. Where the...

Hi Minty, I know this isnt the way your meant to do it. Unfortunately the rules don't apply to every situation, and this is one of them. I need the information to be stored the way I have done it.

Hi, I have a database that will be dealing with customer usage forecasts on stock. As such they will give 12 month projections on the stock they require. I have a form that will be filled in on site by the sales rep, but is there a way to make the total field auto sum after update of the last...

I might be being thick about this. I have spent some time running subforms from a delete and update table. I keep forgetting that the queries would be on their standalone front end and unaffected by anyone else.

Just to follow up - each user has their own copy of the Front End, and multiple users can be using this at the same time. I want to filter the subform where Assigned to = fOSUserName.

Good Morning, I have a subform that is running off of the below query SELECT Tbl_ReqType.ID, Tbl_ReqType.[Part Number], Tbl_ReqType.[Assigned To] FROM Tbl_ReqType WHERE (((Tbl_ReqType.[Assigned To])="Customer Care") AND ((Tbl_ReqType.Complete)=False)) OR (((Tbl_ReqType.[Assigned...

Thanks Doc Man!! Works perfectly :)

Thanks I'll give it a try and see what works

Hi All, I'm gearing up to start a new project, but I have one concern. I need to be able to automatically add records to a table. So. I have Table 1 - Called Tbl_subba. In this I have 4 fields. Id which is an auto ID, Blanket Agreement which is a text field, Detailer which is a text field...

Thanks, How can I take the record selectors off of the Query subform? They look a bit horrible on the subform

Hi Minth, Thinking about this I might be doing it the wrong way. I have sub tables to collect information from my main tables (by my queries) to run my sub forms. Can I run my sub forms straight from the queries?