Probably very simple bu tcan't find it. I'm using a subform to enter one to many relationship. When it goes to subform, cursor is going to first record. Need...
Hi folks I wanted to read processor Serial no from a Access Database & update it to a field to restrict the user from use the database in another computer. Any...
Hi Jerry, try something like this on the Current event of your main form --> =NewSubformRecord() and this code goes behind the main form: '~~~~~~~~~~~~~~ ...
Shamael, Could you explain that to me in more detail. What business problem are you trying to solve with Processor Serial Number? What number does that ...
Dale, This looks like something SQL could do but I don't understand what you are going for here. I think I need to know what business problem you are trying ...
Myra The processor serial number is the CPU ID on a computer, making the machine unique. I haven't found a source yet, but I would imagine there is an API call...
Bill, Wouldn't it be more better to use the log in name of the current user? I don't know what he's getting at. Why he wants to do that. That's why I ask ...
I made a copy of the backend of my database so I could do some work on it over the weekend. I have added the street addresses address to 82,000 record of the...
Myra This information is used to prevent anyone from using a database on more than one machine. It is not a security measure. Or I should say it *shouldn't* be...
Jim Use update/insert queries to get the tables in sync. A better way would have been to make a replicated copy, but since this is only temporary it probably ...
Hi Jim, Link to the tables with data and move it using queries Warm Regards, Crystal * (: have an awesome day :) * MVP Access Remote Programming and Training...
I found the answer. All I had to do was replace "Select" with xlApp.Select and everything formatted perfectly. Linda ... recordset ... formats. ... there ... ...
Good Day All, I have two questions regrading formatting a report: 1) Can an Access report have a grid (lines horizontally and vertically)? 2) Can I print a...
Dear fellow members, Hi, I recently joined this group with great intentions to learn more. Presently am facing the following qurey/syntax problem in a report...
THe way I did it was to take a street guide and go down the north south streets and put the addresses for the cross streets and used an updated query to add...
Hi Amjad, are you trying to get a list of the dates that have been used and then some data about each one? Or are you simply trying to count how many are...
Hi Jim, does your database use seperate fields for house/building number, street name, and N/S/E/W? It would not be a good idea to change the address itself...
Dad 1) Not like Excel. YOu have to use lines or make the borders for the controls solid and place them touching each other. Lines can be controlled through...
Jim I know you've spent a LOT of time on this project. And now is probably a very bad tiem to suggest a new approach, but if you find the address method too...
David 1. Yes, the easiest way is to have borders on your fields and put them right next to each other. (you might want to change the alignment of the text to ...
Bill, That's a good idea except I'm not sure the geocode is specific enough for light poles. You might want to check that first. There is geocoding software...
Thanks Bill, That points me in the right direction. After applying your advice to a report that basically has the same row characteristics, I have a follow-up...
I am trying to get a text box on my form to show the results of an existing query. I tried the expression builder on the text box by selecting the query in...
Hi Ryan, you cannot assign the results of a query to a textbox directly unless you use dLookup, dFirst, or another domain aggregate function. use a combobox or...
Hi, Does anyone know how to change the default settings that appear in the Export Text Wizard? All of the text files we use here are tab-delimited with header...
Elias Build export specs. Those specs hold all teh information you need. Start up an export. Select text file type. After you browse to the folder and enter a...
Dad I suggest queries or even temp tables with queries, depending on how your data is designed. If you've ever looked at the way Access does things, it's all...
All, My query is: INSERT INTO [OVP-Child] ( Claim, Status, Reason, [OVP Amount], [Recovered Amount], Completed ) SELECT RecoupmentCases.ClaimNumber,...
Having problems with message search?
Fill out this form to ensure your group is one of the first to be migrated to the new message search system.
