Search results

Maybe this will help you: http://windowssecrets.com/forums/showthread.php/142196-Access-How-to-intercept-quot-You-must-enter-a-value-in-the-Field-Name-field-quot

We noticed that something isn't the way it should be. My first thought was that there is a problem with the link to the BE. I refreshed the links, still the same issue. Then I copied BE to a new location and made the links. Same thing. So, I copied the BE only after the problem started.

Composite key, tested :-)

I've never tried it, but maybe a composite key from those two columns?

One of the first things I did was a copy of BE and relink

Hi, I ran into this problem and it puzzles me a lot. I created a split database with 15 users on 5 different computers. All of them had Access 2003 and it ran without any problem for like two years. The other day our IT guys upgraded Access to 2007 on my computer. Now, if I use the database...

If part number is your primary key the append query will report an error and it will append only the part numbers that don't exist in your first table.

http://www.access-programmers.co.uk/forums/showthread.php?t=49864 Maybe this wil help you

Here is the picture. For the date part: do you want to display the current date? If so, just enter "Date()" as the control source of your textbox and format it as you want. If you want to see when this user logged in, use another dlookup to display that date. Regards, Samo

Pat, thank you.

I have a database where users are required to log in when they open it. Username is written in tbl_Log along with the time stamp. If you want to populate your textbox, you could create a query that gets the last logged user and use dlookup to populate your textbox. If it is a network database...

In the click event for your button: counter.Value = counter.Value + 1 (counter is the name of the text box that holds your number) then run update query to write counter value also to your table, so that you can retrieve the right number when you load the form

your_control.Value = Date Me.Refresh It is much easier if you don't use spaces i control names. Use underscore for instance.

Hi, I'd delete the button and the macro, add new Search button and write the code to run your query in VBA (it is practically automatic with the wizard for the button). Where you'll have the code for "search" button, add this at the end: text1.value="" text2.value="" . . cmb1.value="" and...

Hi all ! I have a query that pulls all the data about a customer and a form that is based on that query to display that data. Part of it are visits that this particular customer made each month. Is it possible to display that data on a form as a chart (visits/month)? Attached is the picture of...

Sandrra, I have some questions: -how often are the prices changing? -do prices for all the items change on the same date or can you change the price for every product independently? -how many products are there? The problem I ran to is that your dates in all three tables are overlapping and...

I'm trying to get the prices for product x and product y that were valid between 1.8.2012 and 31.8.2012. Those two dates aren't fixed, of course. Other two identical tables hold transport price and discount, with different prices for different dates. The final product should be the price for...

Hi guys, It may be extremely simple, but I'm stuck here. I have a table with prices for two products that were valid from one date to another or are still valid ( picture will explain it all ). How can I get the prices that were valid between dates in textbox1 and textbox2? Desired output from...

Not eliminating the dates as you probably need them. Just rename them to something meaningful like products_date_from and pricing_date_from, since it is confusing (At least for me. I did the same thing once, and was lost with names when I wanted to modify my own queries and forms a week later)...

Of course :-)