JBUDLARWOOD
Last Activity: Nov 5 '07, 02:57 PM
Joined: Oct 6 '06
Location: Ontario, New York
-
Thanks for your help. The answer was in the last entry. -
Missing Data on form
Would anyone have any idea why the form in which I'm working with does not show any fields in the forms view but is all there in the design view? It was working fine and then the data was gone. The form header shows up but not the detail. I'm on Windows XP and Access 2003.
Thanks -
OK, problem somewhat solved. The guy who created all these reports, who is no longer with us, created these reports importing the tables and then using something called DTS. DTS hasn't worked right since he left and I have absolutely no idea how it works. The only fix I can think of is to recreate the queries and linking the tables instead of importing them. This, unfortunately doesn't always seem to work either.Leave a comment:
-
never mind that last reply. When I first read your reply, the info you sent me was scrambled and had extra characters. Anyway, I tried it and it still doesn't work.Leave a comment:
-
Steve.. as you can see by my status, Im a newbie. Where do I enter that line of text?Leave a comment:
-
Steve.. Here is the whole SQL query:
SELECT p21_view_ord_ac k_hdr.order_no, p21_view_ord_ac k_hdr.order_dat e, DateDiff("d",[order_date],Date()) AS Expr1, oe_hdr_salesrep .salesrep_id, p21_view_ord_ac k_line.qty_orde red, p21_view_ord_ac k_line.item_id, p21_view_ord_ac k_line.item_des c, p21_view_ord_ac k_line.unit_pri ce, p21_view_ord_ac k_line.extended _price, contacts.last_n ame, p21_view_ord_ac k_hdr.ship2_nam e, p21_view_ord_ac k_hdr.ship2_add 1,...Leave a comment:
-
No luck Steve. This has been an ongoing problem with my queries for awhile. One day they work, the next day they quit!Leave a comment:
-
Sorry erebus, my last reply was for use in an Access query.Leave a comment:
-
You could try to use Now()-1 or Date()-1.
I'm having date issues myself so I hope it works for you.Leave a comment:
-
Date Expressions in query
Does anyone have any idea why some of the queries that I have that use a Date expression will all of a sudden stop returning results? I have one right now that I am trying to retrieve just the orders entered yesterday. I use DateDiff("d",[order_date],Now()) and I use 1 in the criteria. It has worked fine until today. If I take the 1 away, I get results. -
Read Only Files
I have been moving files from the network PCs to the Server and all the files tell me they are read only. I have went threw all the permissions and securities and I even tried the Microsoft attribute change and still the files read "read only" when anyone tries to access the files threw the network. Any suggestions? It's driving me nuts!!!!!!!!Leave a comment:
-
Read Only Files
I have been moving files from the network PCs to the Server and all the files tell me they are read only. I have went threw all the permissions and securities and I even tried the Microsoft attribute change and still the files read "read only" when anyone tries to access the files threw the network. Any suggestions? It's driving me nuts!!!!!!!! -
Read Only Files
I have been moving files from the network PCs to the Server and all the files tell me they are read only. I have went threw all the permissions and securities and I even tried the Microsoft attribute change and still the files read "read only" when anyone tries to access the files threw the network. Any suggestions? It's driving me nuts!!!!!!!! -
Peter,
I tried it as listed below and it is still not correct. It is still showing items in both locations.
SELECT dbo_p21_view_in v_loc.item_id, dbo_p21_view_in v_loc.primary_s upplier_id, dbo_p21_view_in v_loc.location_ id
FROM dbo_p21_view_in v_loc
WHERE (((dbo_p21_view _inv_loc.primar y_supplier_id)= 11235) AND ((dbo_p21_view_ inv_loc.locatio n_id)<>10 And (dbo_p21_view_i nv_loc.location _id)<>11821) IN (dbo_p21_view_i nv_loc.location _id)...Leave a comment:
-
Here is the SQL that I ended up with. It returns data but it is not correct. It is showing, for example, BQ-1 is in both 11821 & 10 on separate lines. This is an item I should not be seeing. The only thing I can think of is that it is seeing it as two separate records instead of one. This data is coming out of one database file so I don't think that is the case.
SELECT dbo_p21_view_in v_loc.item_id, dbo_p21_view_in v_loc.primary_s upplier_id,...Leave a comment:
-
Nope, same error.Leave a comment:
-
I received a syntax error:
Missing operator in query expressionLeave a comment:
-
Where in the query does this get inserted and what do I have to delete? I tried inserting it in the Group_By line but did not work. Again, I'm a novice to SQL & Access.Leave a comment:
-
Ok folks, thats where I went wrong. I was Importing instead of Linking the tables.
Live & Learn.
Thanks to everyone!Leave a comment:
-
item_id = Text
supplier_id = Number
location_id = NumberLeave a comment:
No activity results to display
Leave a comment: