Good morning, Still a novice Access user but learning fast. I have a database that accesses information stored in an Oracle database using ODBC. I created a...
A couple of ideas come to mind: 1) Secure the database and assign write permissions to the appropriate people (use the security wizard or look for the...
John, Thanks, I think I understand what you're saying, which would be the first step. Two questions: 1. Would it be feasible/better/make sense to create a...
In my efforts to plan ahead, I'm trying to set up my code for the generation of annual run numbers without any need for further intervention. Currently I have...
In addition to Daniel's excellent advice, I'd like to say this: I've never been in an environment where reports were updated more than once a day. If I were...
I have been asked by my network administrators how much band width is used by the connection between the front end and the back end of my database. I am hoping...
I'm wondering if it's possible to define part of a merge field value as bold font when creating a word merge source file in my Access application. Orson ...
I don't know of any way to get a specific amount without specifically watching it with a network monitor of some sort, but I can tell you it's quite a...
"It depends." First, you should install each front end on each user's machine, not in network folders. Access does ALL processing on the client machine, so ...
Sarah- No. You could design an outer form that displays the question and a subform that permits multiple answers - but it would be tricky to allow only one ...
Group, I am trying to have access add a hard return after the short_desc data so that resolution_resp starts about two lines below the short_desc field. I am...
Yup. If you're going to use DateAdd, you need "ww". Or use the formula I posted earlier. The integer portion of a date/time variable is number of days, so...
You can add a return in a form control source with Chr(13) & Chr(10) like: ="test" & Chr(13) & Chr(10) & "test2" Paul ... data ... Access2K. I ... Response ...
If you are using this in a control source it would be: ="Short description of issue: " & [short_desc] & chr(13) & chr(10) & "Resolution Response: " &...
Greetings: I have a data entry screen and the tab order is hard to set with code. The trick I learned with VB doesn't work where you set them from the last...
Hello Everybody, I am looking to improve my skills in Access and I was told to give this exam, has anybody taken this exam before, if yes can anybody pls tell...
This may sound crazy, bought I need 153 fields for one table. I am need to develop a database from one form in particular to collect data only. All have to be...
Ken- Works for me when I add: Me.TxtC1.SetFocus .. at the end. John Viescas, author "Microsoft Office Access 2003 Inside Out" "Running Microsoft Access 2000" ...
Brian- You can define up to 255 fields in an Access table, but the total "fixed" length cannot be more than about 4000 bytes. By "fixed" I mean the minimum ...
The exam won't "teach" you anything, but preparing for the exam might. Many MVPs have long criticized the Access exam for not putting enough emphasis on ...
Hello Brian You are right. 153 fields for one table is crazy. Sounds like you need to brush up on normalized data in a relational database and the design...
Set the tab order from the properties window of the form. Neil Squires ... ===== Neil Squires - Relational Database Design GreaterDesignConcepts@... ...
Write a function for it and place it in a public code module. Then call the function from wherever you need the number and you can make it as complicated or ...
Sorry...I made one development, but I am not 100% there. If I isolate one product number to sum, this statement works: SELECT [qrycount-begin].ProductNumber,...
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.
