Recent content by dylan_dog

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