Search results

Glad I asked! I couldn't forsee any problems with this ( but being a newbie...) let me make sure I understand this. This would take the place of my current (spreadsheet type) table. Using whatever headings i choose. tblCodes: CodeID (autonumber primary key) ShortName LongName ParentID (foreign...

I currently have a DB ( which runs good) with a table called RMAOptions. This table contains (by column) lookup data for list & combo boxes, IE. column 1 = TECHID column 2 = STATUS column 3 = so on and so forth Is it cosidered acceptabe to have a table like this or should each column be in...

Thanks for the fast reply all! Using the isnull BEFORE the field did the trick. Just started using access with some VB and its amazing how much better your database can be! This forum has been a great help. Thanks again

good morning all, I am using the afterupdate event on this forms field. If this date field is NOT EMPTY, then i want the next field to be visible. Here is the code i have If Me.quotedate = ????????? Then Me.quotehow.Visible = True Else Me.quotehow.Visible = False End If I have done...

yep, down to the nitty gritty! doing the "jog" thing seemed to have done it, thanks. The fields on the report have a gray background so when printed ( or on screen) you could see the little ofset in the box height, only reason for being so picky. Thanks

This just seems strange! I have a report that most fields are fine. There are 2 fields that i just can't set the height on. 0.1667" is what the fields are all set to. 2 fields ( that have back coloring to them) are ay 0.166". I can't get them to 0.1667" any ideas why this might be? Thanks Kevin

I ran the DB splitter and It didn't do what I thought it would. It did it better! The tables are ALL linked from the front end. I thought the backend would have some linked tables, but I see now thats not the case.

I currently have a .mdb on a server, 4 tables within the .mdb, 8 linked tables to another access .mdb. My question is, if I split the db into an FE-BE will there be to many linked tables??? I think the links will be something like.. FE to BE to BE, make sense?? Thanks Kevin

I currently use barcode scanners for data entry into my database. done in forms and DAPs. All works great! you need to check the configuration in your scan gun. the scan guns are configurable for such items as, a preamble, suffix, auto carriage return, tab........ Check the scanners...

Hi all, I can force the data in a form to be written back to a table as uppercase, no problem there. I have users who enter the same data through a Data Access Page ( saves on licensing). Can the entries in the DAP be written back as uppercase? Thanks Kevin

I figured it out. I had to build an "In-Line function" instead of the straight query i had done. The "N" that was inserted into the SQL statement is because the field is a data type "nvarchar"

I have a succesfull .mdb, and would now like to start "testing the waters" of a project file. I designed a query from 5 table. If i leave the criteria blank the query runs fine. If i place criteria for a user prompt the SQL looks like this and i get no prompt and no data. WHERE (dbo.[TLA...

That was it! Thanks Pat

I have a report based on a query, calculates a date in an unbound text box. I need to Avg the textbox. I created another unbound text box w/ =Avg[text2] Text2 being the calculated box with the dates When I run the report it prompts me for "Text2" How can I fix this? Thanks Kevin

I currently have a report that I calculate 2 values on --- "CUSTTT" and "BUSTT" these are done using a function to calculate the number of days between dates. basically ---- CUSTTT=recdate-issuedate BUSTT=shipdate-recdate This works great and I don't store the results in a...

Thanks JonK!

Its almost there, but not quite. If ENDDate is Null I need the function to make the result (DATEDIFFW) = 0, to show zero in the control box. Any suggestions? Below is the code as I have it now. Function DateDiffW(BegDate, EndDate) Const SUNDAY = 1 Const SATURDAY = 7 Dim NumWeeks As Integer...

It looks like i fixed it. I placed the following 2 lines before the line that is giving me the error. If IsDate(dStartDate) = False Then Exit Function If IsDate(dEndDate) = False Then Exit Function Thanks

Hi all, I am calculating business days between 2 dates using a function I found here It works great, as long as both dates are NOT NULL. In my form, the record may not have a "received date" as its not here yet. When i open the form I get a message "invalid use of null" on the SELECT CASE...

That makes sense. Thanks!