Search results

Hi Brian, thanks for your reply. Yes, that's what i found when i was testing the queries. Is there a way around this? Is there a way of checking the Total field in Hold, if the OrderNo in Goods and Hold match? And if OrderNo in Goods and Hold do NOT match, then don't check the Total field?

Hey there, The title might not make much sense, but thanks for viewing, i'll do my best to explain with as much detail as possible. I am currently creating a database that has two tables. Hold OrderNo Total Goods OrderNo Total I have already created a query that validates the OrderNo...

Thanks for your reply! I resolved this by creating an update query that would input an "X" into a field, i then ran the report on the list, got exactly what i needed. I'm just about to post a new thread though in Queries, so if you fancy helping that would be greatly appreciated!

Afternoon All! I have a slightly confusing question regarding a query/report. My database has two tables: hold order These two tables have one related field. In hold, this field is called "PO". In order, this field is called "DocNo". I have built a query to show me any record that do not...

Hey there, I'm trying to remove duplicate records that have the same ID and Total. These records are in one table. I've just using the following code, however it returns no records. SELECT First(test_order.OrderID) AS [OrderID Field], First(test_order.Total) AS [Total Field]...

That's it! Thank you! Could i be so cheeky as to ask you to explain your code?

Thanks for both of your suggestions, unfortunately neither of them worked. "#[Start Date]#" returned an invalid expression, and "between [start date] and [end date]+1" returned a "This expression is typed incorrectly" error. I've got absolutely no further ideas how to get this working. I'm...

Thanks for that reply! I just tried your suggestion, however i get the familiar "This expression is typed incorrectly" error message. Would it be possible to use => [Start Date] AND <= [End Date] ? I've tried this, but can't get it working.

Hey! I've created a query, its basically querying a table containing sales records. I have entered "Between [Start Date] and [End Date]" in the criteria for the Date field, as i want the user to specify the date range. However, when i enter the Start Date as 28/09/10 and End Date as...

Also, a picture is attached as an exact example of what i mean. I'm aware the screenshot isn't of an Access application, but it's just the principal that i'm enquiring on.

Hey, Pretty general question, but i can't seem to find an answer anywhere in any previous threads. Are tabbed menus a possibility in Access? If so, does anyone have any info they can point me towards? I'm aware i can create my own toolbar, however i want to keep everything inside one form...

Why don't you create a data source via ODBC? I imagine that would work and resolve any connectivity/authentication issues.

I used to use a little tool called HTML lock, it encrypts your web page you can assign user login credentials through a .csv or .xls file. Pretty handy. If you want it, let me know and i'll dig it out for you.

Create a macro, choose "maximise" action. Save. In the form, right click out of your form, Properties, "Event" tab. Then select "On Open", Select the drop down and choose your macro. Let me know if this doesn't work.

Open the table in Design View, find the field in question, change the "Required" option to "Yes" This is the simplest way, you don't need to use code for this

Change the field in question to a Required field?

Hey there, Thanks for taking the time to help me thus far with all my questions. Also, if this is in the wrong area, please feel free to move it Moderators. I put it in here as it covers queries, reports and SQL. I have a new project under my remit, I’ll do my best to explain it as...

That's interesting, how can you actually 100% prove that it didn't happen? You can say its unrealistic, but to say it "could have never happened" is incorrect. You weren't alive thousands of years ago, you have no way of proving what was fact or fiction.

xbox 360, it's really really really really bad.

Nooo i don't hate it. it's an absolute classic, but i hate the fact that i never completed it :( Quantum of Solace, now THAT was a terrible game.